Skip to main content
トピック#Median

#Median0 人がディスカッション中

質問する...
Athar Naeem が「* CRM Analytics (fka Tableau CRM) *」で投稿
2019年12月9日 20:14

Hi,

 

Has anyone experienced this 'Query Execution Failed' error in EA?

Considering that you have enabled the subtotal feature in EA compare table.

Add two Dimensions and a measure in a compare table, enable the subtotal for compare table. Now Take a median of any measure, it ends up with Query Execution failed error.

Not sure if I am doing anything wrong here or this functionality is broken for Median of a measure.

Thoughts?

 

Thanks,

Athar

1 件のコメント
  1. Athar Naeem
    2019年12月9日 20:16
    PS: I tried doing the same thing in SAQL and got the same Query Execution failed error in SAQL. if I do the same thing with a sum instead of the median, it works fine.
コメントを記入...
0/9000
Athar Naeem が「#Query Execution」で投稿
2019年11月15日 16:30

Hi,

 

Has anyone experienced this 'Query Execution Failed' error in EA?

Considering that you have enabled the subtotal feature in EA compare table.

Add two Dimensions and a measure in a compare table, enable the subtotal for compare table. Now Take a median of any measure, it ends up with Query Execution failed error.

Not sure if I am doing anything wrong here or this functionality is broken for Median of a measure.

Thoughts?

 

Thanks,

Athar

コメントを記入...
0/9000
Tableau Community Forums Member (Inactive) (Salesforce の Member of the Tableau Community Forums) が「#All」で質問
2016年1月7日 10:29
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 件の回答
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    2016年1月7日 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