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, 2019 in Tableau by Priya
239 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, 2019 by anonymous
• 33,010 points

Related Questions In Tableau

0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10 in Tableau by Neha
• 8,740 points
96 views
0 votes
0 answers

How to we make a filter(from a calculated field) a context filter in Tableau

Booking Size is a computed field with ...READ MORE

Mar 10 in Tableau by Neha
• 8,740 points
149 views
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 sdfg
• 5,550 points
460 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,230 points
8,154 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,230 points
837 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, 2019 in Tableau by Cherukuri
• 33,010 points
3,428 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, 2019 in Tableau by Cherukuri
• 33,010 points
597 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP