Getting incorrect tooltip while toggling through quick filter

0 votes

What I did?

I created a calculated value in order to find out the grade for business, and this is colourmap (in tab Grade per Location)

enter image description here

And when I hover over datapoints on map (tab Map), it displays correct Grade, i.e. D for Shish Boom Bah Car Wash

enter image description here

But as soon as I select any location from a drop-down, all grades are A

enter image description here

Following are the calculated field:

Tot_Avg:

{ EXCLUDE [Location (Loc)] : AVG([Rating]) }

Avg_Rating:

AVG([Rating])

And here are the conditions for receiving an A:

IF [Avg_Rating]  > ATTR([Tot_Avg]) - (.10 * ATTR([Tot_Avg]))
THEN "A"

Can someone help?

Jun 27, 2018 in Tableau by Atul
• 10,240 points
772 views

1 answer to this question.

0 votes

I think what you want to ask is your confusion is in what that EXCLUDE is doing. 

It is NOT ignoring filters. It's just saying not to group by Location when aggregating AVG([Rating]). When you filter out all but one location, AVG([Rating]) and { EXCLUDE [Location (Loc)] : AVG([Rating]) } become equivalent, because with either calculation, you're averaging for all points in your filtered partition.

As a result, your condition for receiving an A will always be true if there's only one location. (Check the math: X > X - .1X → X > .9X)

Here's a different way to get what you're after. Make a calculated field (I'll call it Location Filter):

LOOKUP(ATTR([Location (Loc)]),0)

Then trash your Location filter and replace it with that field. We're doing something sneaky here - we're making the exact same filter as we had before, but we're disguising it as a table calculation (by using LOOKUP()). Tableau doesn't execute table calculations until after it's created the filtered partition, so we've tricked it into letting us use every location while still just examining one.

answered Jun 27, 2018 by ffdfd
• 5,550 points

Related Questions In Tableau

+1 vote
1 answer

Tableau tooltip incorrect when toggling through quick filter

I think your confusion is in what ...READ MORE

answered Jul 21, 2018 in Tableau by Atul
• 10,240 points
1,317 views
0 votes
1 answer

Tableau Quick Filter- How do I make it display a description but filter on a key?

Simply create a new calculated field with ...READ MORE

answered Apr 21, 2022 in Tableau by Neha
• 9,020 points
379 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

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

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 21, 2018 in Tableau by Atul
• 10,240 points
5,034 views
0 votes
1 answer

Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 10,240 points
1,472 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
2,144 views
0 votes
1 answer

create filter from multiple data sources

Hi Nithin, 1. You can perform full outer ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
688 views
0 votes
1 answer

Using Top in filter.

Hi Tejas, The top filter is used to ...READ MORE

answered Apr 30, 2019 in Tableau by Cherukuri
• 33,030 points
650 views
0 votes
1 answer

Can someone tell me about some tips and tricks while using tableau?

1. Tableau tips and tricks: Calendar in ...READ MORE

answered Jul 4, 2018 in Tableau by ffdfd
• 5,550 points

edited Sep 21, 2021 by Soumya 603 views
0 votes
1 answer

How to hide measures on a Tableau filter?

Number of Records is just a predefined ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
2,384 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP