Skip to main content

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 Antworten
  1. 7. Jan. 2016, 11:45

    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

0/9000