Two different averages on a Tableau graph - for complete versus filtered data as a reference line

0 votes

How to plot two different averages on a graph - for complete versus filtered data as a reference line?

Mar 13, 2019 in Tableau by Sindhu
2,818 views

1 answer to this question.

0 votes
Hi,

You can plot any number of reference lines required on the graph. Its very simple, follow below steps.

1. Plot the graph for required fields.

2. Then click on analysis pane on the left side of the screen.

3. Create a constant line with average for complete data.

4. Add the filter and now click on Reference line and drag and drop on the table.

You can observe the changes with 2 lines showing the difference. ( when the filter is removed both lie on the same line )

Hope this helps you.
answered Mar 13, 2019 by Cherukuri
• 33,010 points
One more way is to drop the calculated field in details section and then use an average line to show the field value, then edit the line and check the drop down section, the field will be available.

Related Questions In Tableau

0 votes
1 answer
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,230 points
312 views
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 20, 2018 in Tableau by sdfg
• 5,550 points
7,376 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
11,312 views
0 votes
1 answer

average line on chart of averages

Hi Anitha, To add average line already aggregated ...READ MORE

answered Apr 23, 2019 in Tableau by Cherukuri
• 33,010 points
348 views
0 votes
1 answer

Dynamic Reference line in tableau

Hi Nithin, You can make the reference line dynamic using ...READ MORE

answered Apr 24, 2019 in Tableau by Cherukuri
• 33,010 points
2,962 views
0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 6, 2018 in Tableau by Atul
• 10,230 points
4,464 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,937 views
0 votes
1 answer

Not used field as a reference line or line across a chart

Hi ayushi, You can use a field that ...READ MORE

answered Apr 17, 2019 in Tableau by Cherukuri
• 33,010 points
232 views
0 votes
1 answer

Sum Filtered Data in Tableau

Hi Anitha, Its quite simple, To use a ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,010 points
8,074 views
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