7 Replies Latest reply on Feb 26, 2016 7:34 AM by Shinichiro Murakami

# Better way to filter and show count

I'm still a Tableau greenhorn and I'm always questioning if I'm attempting to solve something in the best possible manner.  I was asked to help figure out a problem the other day a user was having building a view and I came up with the solution to it, but I'm not sure if there are other and perhaps better ways to solve it.  Basically the person wanted to show a map and have the mark label be the count of customers that make up the dollar amount for a given area.  And then the user wanted to have a way to filter by an amount and have the count of customers reflect the number customers meeting the amount threshold.  Attached is my solution for this using some made up data.  I simulated what the user originally was attempting to do in the First Attempt sheet and the Working sheet shows my solution.  I'm a little confused on how to explain the why there is difference other than I know the aggregation (SUM(Amount) as a filter) is what was throwing off his solution.  Thank you for any help or ideas you may share.

• ###### 1. Re: Better way to filter and show count

"Working Sheet" is filtering each customer level threshold.

And First Attempt is filtering sum of states.

In other words, "First Attempt" filters "States" itself and the number of count on each state never change.

"Working Sheet" filters customers and the number on the state differs from threshold.

Shin

1 of 1 people found this helpful
• ###### 2. Re: Better way to filter and show count

Thanks Shin for the reply and explanation.  That does make sense and answers the question why the behavior is different.  Do you have suggestions for a different\better way to achieve the same desired result?

• ###### 3. Re: Better way to filter and show count

What is the desired result?

Shin

• ###### 4. Re: Better way to filter and show count

Sorry I wasn't clear.  To be able to show which customers meet the threshold and show the count of those customers in the state and the total dollar amount represented by those customers.  In others, achieve the same result was the "Working" sheet.

• ###### 5. Re: Better way to filter and show count

I think you are already doing good, but little bit simpler way is below.

You don't need to create parameter, and has capability of selecting "Range"

Thanks,

Shin

9.2 attached

• ###### 6. Re: Better way to filter and show count

Agreed.  I thought I tried this but was getting the results of the first attempt.  Thank you for sticking with me on this Shin.

• ###### 7. Re: Better way to filter and show count

You are very welcome

Happy Friday.

Shin