4 Replies Latest reply on Feb 27, 2017 6:16 AM by Jim Dehner

# Struggling to get a proper line chart

Hi there,

I am still new to Tableau, so I come across some problems from time to time. This time I failed to solve it on my own - again. So here is my latest issue.

My data set includes data about three fictional higher education institutions for the years from 2010 to 2012. I want to construct a line chart showing the total number of students and the number of students at two of the three institutions (each institution separately).

I know how to get a second line for just one institution using a parameter. But I fail to add a third. Then I tried to use sets of just one institution to draw the lines, but I if I do this, the number of students at the set's institution is subtracted from the total number of students.

My original data set contains data on more than 300 institutions, 40 different subjects and so one. So I made up a fictional sample of just three institutions to demonstrate my problem. I attached the workbook to that post.

Regards,

Mark

• ###### 1. Re: Struggling to get a proper line chart

Hi Mark,

I still don't understand your question perfectly, but below approach might help.

From edit data source, duplicate the sheet with "join"

Then, you can get this table.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Struggling to get a proper line chart

Hi Mark

Is this what you are looking for:

Here is the process:

1. convert your year1 to an actual date with >>MAKEDATE([Year1],1,1)
2. calculate the Total Students as >>{ FIXED [year date] :sum([Students])}
3. Then drag:
1. the actual date to columns
2. the student count to rows
3. and the total student calculation to rows
4. two time phased charts should appear
5. right click the total students pill on the rows shelf
6. select dual axis
7. in the chart the remains right click the right axis and click synchronize axes

that should do it

let me know if this helped

Jim

2 of 2 people found this helpful
• ###### 3. Re: Struggling to get a proper line chart

Thanks to both of you!

Jim, your advice is actually the one I was looking for. Thats a lot, Tableau is now doing what I want it to do!

Best Regards,

Mark

• ###### 4. Re: Struggling to get a proper line chart

Thanks Mark