9

I read every possible forum and I couldn't find a specific answer. I'm new to Tableau and I need to perform what I thought would be a very simple task but I can't figure it out.

I need to create a chart with multiple lines plotted in the same graph. On one column, I have a timestamps in seconds (decimal). For each timestamp value, I have 4 columns associated (Temperature, Pressure, Humidity, Voltage) and I need to visualize how they trend over time. The data in Excel looks something like this (I simplified it for visualization purpose):

enter image description here

In Excel, it takes me less than seconds to obtain a chart that looks like this:

enter image description here

How can I replicate the same exact chart in Tableau? I would like someone to tell me exactly how each column should be formatted, if the data has to be a dimension or a measure and data type for each (string, number etc) and what steps to take in the chart. I would do this in Excel but the file is almost 1M rows and Excel keeps crashing.

Mehul Katara
  • 836
  • 11
  • 31
Francopd
  • 115
  • 1
  • 1
  • 6
  • 1
    The feature you need to learn about in Tableau involves using the pseudo-fields Measure Names and Measure Values. Read about them in the online help.You can also look for the term "blended axis". – Alex Blakemore Jun 23 '17 at 02:24

2 Answers2

11

  1. drag & drop measure values & timestamp.

    enter image description here

    EDIT - first make Timestamp a dimension instead of a measure, and make sure it remains continuous instead of discrete. So you should not see the word SUM in front of Timestamp

  2. remove no. of row & timestamp from the measure values.

    enter image description here

  3. uncheck aggregate measure.

    enter image description here

EDIT this step is not usually needed or desirable. If you do have multiple recordings per Timestamp, you will want to select the best aggregation function for each measure, perhaps AVG or MEDIAN instead of SUM

  1. select line from mark and drag measurement to color

    enter image description here

Alex Blakemore
  • 10,521
  • 2
  • 22
  • 46
Mehul Katara
  • 836
  • 11
  • 31
0

If your X-axis is a Date Column, (i.e. You have a list of dates on your X-axis)

  • Drag your 'date column' to Columns and choose Month/Year/Week etc. and make it continuous
  • Drag 'Measure Names' to Filters and choose your Measures
  • Drag 'Measure Values' to Rows
  • Drag 'Measure Names' to the Colors section of the Marks card
Vivek Sivalingam Ramanathan
  • 151
  • 1
  • 3