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, 2019 in Tableau by Nithin
1,039 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, 2019 by Cherukuri
• 33,030 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
11,782 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 13, 2018 in Tableau by xyz
• 1,560 points
7,271 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 29, 2018 in Tableau by Atul
• 10,240 points
1,022 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
1,130 views
0 votes
1 answer

Dual axis chart - Edit Axis

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

answered Apr 23, 2019 in Tableau by Cherukuri
• 33,030 points
867 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 29, 2018 in Tableau by Atul
• 10,240 points
8,795 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 24, 2018 in Tableau by Atul
• 10,240 points
872 views
0 votes
1 answer

Stacked bar and line chart -Tableau

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

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,030 points
21,504 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, 2019 in Tableau by Cherukuri
• 33,030 points
3,579 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