How to perform a calculation using one variable with an aggregation in calculated field?

0 votes
How to perform aggregation of one variable over total data using a calculation field? I want to calculate the average or sales in one region to total and show it in the tooltip,
May 20 in Tableau by Priya
24 views

1 answer to this question.

0 votes
Hi,

You can use the calculative field and Fixed Lod for your problem as

AVG(Sales) / { AVG(Sales) } where { AVG(Sales) } is avg sales for each region over complete data.

If you want to calculate for one region only then,

{ FIXED [Region] = "Canada" : AVG( [Sales] ) } / { AVG( [Sales] ) }
answered May 20 by anonymous
• 22,110 points

Related Questions In Tableau

0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,530 points
36 views
+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,530 points
274 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
1,223 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22 in Tableau by Cherukuri
• 22,110 points
46 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
1,621 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

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

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 22,110 points
83 views
0 votes
1 answer

Is it possible to do a % of Table with an attribute in Tableau?

Hi Nithin, yes it is possible to ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 22,110 points
22 views