Skip to main content
Topics#AllTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #All
Jan 7, 2016, 10:29 AM

Filtering on a measure.

Hello,

 

When filtering on a measure there is an option for picking "All values" or Specific value.

 

From the Super Store Example:

 

We create State Vs Sales.

 

We drag sales to the filter shelf, now it asks a question

 

"How do you want to filter on [Sale]"?

 

#ALL VALUES

⌗SUM

⌗AVG

#MEDIAN

 

If we select sum and say atleast 100K, it would display State Vs Sales for all the states that have sales greater than 100K.

 

I don't understand the option of "ALL VALUES", if we select "ALL VALUES", does it mean to say, SUM of SALES>100k and AVG of SALES>100K and MEDIAN of SALES>100K?

In what scenario do we even use an option like this?

 

Thanks

5 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jan 7, 2016, 11:45 AM

    Hi venkatesh.

     

    All Values--- filters the data at the row level in the database.

    Hi venkatesh. All Values--- filters the data at the row level in the database. sum--- It gives the range from least sales value to maximum sales value with respect to state.

     

    sum--- It gives the range from least sales value to maximum sales value with respect to state.

     

    pastedImage_6.png

     

    Average---It gives the range from least average sales to maximum avg sales with respective to state..

    pastedImage_9.png

     

    It works same to other aggregate functions also..

     

    I hope it is helpful for you..

     

    Thanks

    Deepak

Write an answer...
0/9000