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 in Tableau by Sindhu
266 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 by Cherukuri
• 32,260 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

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
53 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 19, 2018 in Tableau by Atul
• 5,530 points
496 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
2,092 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,372 views
0 votes
1 answer

average line on chart of averages

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

answered Apr 23 in Tableau by Cherukuri
• 32,260 points
46 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 in Tableau by Cherukuri
• 32,260 points
108 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 5, 2018 in Tableau by Atul
• 10,240 points
1,917 views
0 votes
1 answer

How to aggregate multiple column in Tableau?

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Jul 9, 2018 in Tableau by Atul
• 5,530 points
272 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 in Tableau by Cherukuri
• 32,260 points
49 views
0 votes
1 answer

Sum Filtered Data in Tableau

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

answered Mar 13 in Tableau by Cherukuri
• 32,260 points
781 views