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 3,655 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
• 33,030 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.

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

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

+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

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

0 votes
1 answer

## average line on chart of averages

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

0 votes
1 answer

## Dynamic Reference line in tableau

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

0 votes
1 answer

## How can I count the aggregate function in Tableau

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

0 votes
1 answer

## How to aggregate multiple column in Tableau?

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

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

0 votes
1 answer

## Sum Filtered Data in Tableau

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