Looking for Expression for doing Sum of Averages. Something like this: Sum(Average Score for each Client)

My data basically looks like this:

Client Name Score
ABC 5
ABC 5
ABC 5
ABC 5
ABC 5
ABC 5
XYZ 10
XYZ

10

I want to be able to calculate the Average of the averages. In this case: ABC avg = 5, XYZ average = 10. the Average of Averages = 7.5 but when this is done in spotfire (e.g. single bar chart or KPI Card) ... it shows the average accross the entire list Sum of Score / Count of Rows which yields 6.25 in this case. I need for the solution to be dynamic (filter sensitive). Calculated column will not do...

Any thoughts anyone? 

Attachments

AttachmentSize
Binary Data average_of_averages_example.dxp302.82 KB

(1) Answer

Login