Skip to main content
주제#Median

#Median토론 중인 항목 0개

질문해 보세요...
Athar Naeem 님이 * CRM Analytics (fka Tableau CRM) *에 글을 올렸습니다
2019년 12월 9일 오후 8: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일 오후 8: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일 오후 4: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