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

Question

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

Answer 1

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.

Comments

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.