Dynamic Reference line in tableau

0 votes
Ho to plot the reference line to a chart that shows visual according to parameter selection? I want to show average sales across regions for total in a bar chart but avg of each category in the form of the reference line.
Apr 24 in Tableau by Nithin
10 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 Nithin,

You can make the reference line dynamic using a parameter.

 Follow the below steps to make a dynamic reference line -

1. Create a bar chart with the region and average sales.

2. Add a parameter for the selection.

3. Then create a calculated field to match the parameter and calculate the aggregate that you want to use as a reference line.

Example, IF [Category] = [Cat Parameter] THEN [Sales]

                 ELSE 0

                 END

4. Add the created calculated field in Details shelf.

5. Now Add an Average reference line on the chart click on the edit line and select the calculated field.

6. Click OK.

Hope it helps you.

answered Apr 24 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
945 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
290 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

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

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,810 points
34 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
• 13,940 points
13 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
956 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

Aggregating from multiple columns in Tableau

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

answered Aug 17, 2018 in Tableau by Atul
• 5,470 points
59 views
0 votes
1 answer
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 27 in Tableau by CHERUKURI
• 13,940 points
22 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.