Plotting multiple lines in Tableau

0 votes

I looked in every forum I could find but couldn't locate a precise solution. I'm new to Tableau and need to do a task that I assumed would be simple but can't seem to figure out.

I'm trying to make a graph with numerous lines drawn on it. I have timestamps in seconds in one column (decimal). I have four columns connected with each timestamp value (Temperature, Pressure, Humidity, and Voltage), and I need to see how they progress over time. The data in Excel looks like this (I simplified it for the sake of visualisation):
Grt0i.png (333×289)

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

enter image description here

How can I make a Tableau version of the same chart? I'd want someone to explain how each column should be structured, whether the data must be a dimension or a measure, the data type for each (string, integer, etc. ), and the graphic steps to take. I'd do it in Excel, but the file is about 1 million rows long, and Excel keeps crashing.

Mar 10 in Tableau by Neha
• 6,260 points
27 views

1 answer to this question.

0 votes
  1. First, 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. Then remove no. of row & timestamp from the measure values.

    enter image description here

  3. Then 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. Now select line from mark and drag measurement to color

    enter image description here

answered Mar 14 by Vaani
• 5,040 points

Related Questions In Tableau

0 votes
1 answer

Aggregating multiple column in Tableau

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Jun 30, 2018 in Tableau by sdfg
• 5,550 points
197 views
0 votes
1 answer

How to aggregate multiple column in Tableau?

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Jul 10, 2018 in Tableau by sdfg
• 5,550 points
1,912 views
0 votes
1 answer

Aggregating from multiple columns in Tableau

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Aug 18, 2018 in Tableau by sdfg
• 5,550 points
4,689 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
10,913 views
0 votes
1 answer

How do I create a bubble chart that is aligned in Tableau?

Put your dimension in the column shelf Put ...READ MORE

answered Apr 18 in Tableau by Neha
• 6,260 points
28 views
0 votes
1 answer

Alternative to Tableau Public

Tableau Desktop offers a 14-day trial period ...READ MORE

answered Apr 12 in Tableau by Neha
• 6,260 points
28 views
0 votes
0 answers

How to merge two data sets in Tableau via relationship?

I'd want to integrate two data sets ...READ MORE

Apr 14 in Tableau by Neha
• 6,260 points
19 views
0 votes
1 answer

How interactive graphs are generated in Tableau?

Lot of back end code is shared ...READ MORE

answered Apr 14, 2018 in Tableau by xyz
• 1,560 points
218 views
0 votes
1 answer

Creating a stacked waterfall chart in tableau

You can try this as a solution: 1.) ...READ MORE

answered Apr 5 in Tableau by Vaani
• 5,040 points
66 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP