average line on chart of averages

0 votes
How to add an average line to an average bar chart? If I add avg line, it is showing incorrect input.
Apr 23 in Tableau by Anitha
13 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Anitha,

To add average line already aggregated fields in a chart, you can use fixed LOD to show the overall average over each average.

Follow the below steps:

1. Construct Avg bar chart for requiring dimension and measure.

2. Add a Fixed LOD expression using calculated field as  { AVG([MEASURE]) }.

3. Now add the created field in details shelf.

4. Add an average line on the bar chart and edit the line.

5. Once the edit dialog box opens, click on value drop down and select the created field from the list.

6. Now the average line is shown in the average bar chart.

Hope this helps you.
answered Apr 23 by CHERUKURI
• 13,940 points

Related Questions In Tableau

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,200 points
946 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,969 views
0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer

Displaying Aggregations across bar chart in Tableau

Hi Sindhu, 1.You can use average lines to ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
19 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
• 13,940 points
10 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,200 points
957 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,470 points
70 views
0 votes
1 answer
0 votes
2 answers

How can I add text in the centre of a Donut Chart ?

Hi, You can read this for creating a donut ...READ MORE

answered Apr 4 in Tableau by CHERUKURI
• 13,940 points
301 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.