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
3,104 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,050 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

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,020 points
225 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,230 points
434 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 ffdfd
• 5,550 points
8,631 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
13,041 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,050 points
503 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,050 points
3,304 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,726 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,114 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,050 points
295 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,050 points
9,385 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