0 votes
1 view
in BI by (17.6k points)

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. In one column, I have a timestamp 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.

1 Answer

0 votes
by (47.2k points)
  • Drag & drop measure values & timestamp.
    enter image description here

  • First, make Timestamp a dimension instead of a measure, and make sure it remains continuous instead of discrete. So you don’t need to see the word SUM in front of Timestamp

  • remove no. of row & timestamp from the measured values.
    enter image description here

  • uncheck aggregate measure.
    enter image description here

  • 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

  • Now, select line from mark and drag measurement to color
    enter image description here

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...