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, 2022 in Tableau by Neha
• 9,020 points
1,354 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, 2022 by Vaani
• 7,070 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 ffdfd
• 5,550 points
706 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 ffdfd
• 5,550 points
2,697 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 ffdfd
• 5,550 points
5,919 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
15,311 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, 2022 in Tableau by Neha
• 9,020 points
1,125 views
0 votes
1 answer

Alternative to Tableau Public

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

answered Apr 12, 2022 in Tableau by Neha
• 9,020 points
853 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, 2022 in Tableau by Neha
• 9,020 points
1,205 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
789 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, 2022 in Tableau by Vaani
• 7,070 points
1,478 views
0 votes
1 answer

combine two data sets in tableau so that I can show a forecast for the next 3 months

I believe the best approach is to ...READ MORE

answered Apr 5, 2022 in Tableau by Vaani
• 7,070 points
885 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP