Create subset and overall value line chart

0 votes

This may sounds very simple but I am finding hard to get that. I have a data with value in one column and category in another column. i.e.,

Value Category Month
100     A       Jan
300     A       Feb
200     A       Mar
459     B       Jan
334     B       Feb
765     B       Mar

I am trying to use a line chart in tableau with Month on X axis and Value on Y-axis.Basically I am trying to add two lines, one for overall value for that particular month and another line for Category A alone for that particular month. Say for example the overall value for Jan as 559 and another line in same graph for category A for Jan as 100.

Though it sounds so basic, I find hard to achieve this. Should I create a calculated field for this or is there any simple method that works for this.

Mar 13 in Tableau by Nithin
46 views

1 answer to this question.

0 votes

Hi Nithin,

1. First create a line chart for month vs value for both categories A and B.

2. Add category in filter and select only A.

3. Create a calculated field to find the total value for month by { FIXED [Value] : SUM([Value]) }

4. Now make a dual axis chart of total vs value for month .

5. Now you will get the below line chart.  

Hope this helps you.

answered Mar 13 by Cherukuri
• 25,820 points

Related Questions In Tableau

0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
2,803 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
1,806 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
43 views
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
80 views
0 votes
1 answer

Dual axis chart - Edit Axis

Hi Riya, Dual axis chart automatically makes the ...READ MORE

answered Apr 23 in Tableau by Cherukuri
• 25,820 points
34 views
0 votes
1 answer

Creating a dual axis chart with same measure in Tableau

Yes, this is possible. Drop the measure in ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
1,163 views
+1 vote
1 answer

Non-overlaid measures in dual axis chart within Tableau

The missing step is to specify the ...READ MORE

answered Jul 23, 2018 in Tableau by Atul
• 10,240 points
40 views
0 votes
1 answer

Stacked bar and line chart -Tableau

Hi,  Follow these steps to add a stacked ...READ MORE

answered Apr 3 in Tableau by Cherukuri
• 25,820 points
500 views
0 votes
1 answer

How to show actual and forecast in same line chart?

Hi Sindhu, Follow the below steps: 1. Create a line ...READ MORE

answered May 23 in Tableau by Cherukuri
• 25,820 points
35 views