Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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

If you also want to learn Tableau and make your career in it then I would suggest you must take up the following Tableau Course online. 

Related questions

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...