not very complex calculation

[#1]

Hi!

It's realy not very complex calculation, but it make me stuck.

My problem:

i need to calculate something like this

Data:

LOAD * INLINE [
 man, value
 man01, 3
 man02, 4
 man03, 2
 man01, 3
 man01, 4
 man03, 2
 man02, 5
 man02, 3
 man02, 4
 man02, 5
];

I need to know how many men have sum(value) > 11 (call men, who have sum(value) > 11, like cool_men),

and then count(distinct cool_men)/ count(distinct man)

It mast be gauge chart.

Regards,

Igor

[matt_crowther · Accepted solution]

Igor,

Attached file should do it using the aggr() function.

The key element is:

=count(if(aggr(sum(value),man)>11,man))

And in a gauge:

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Thank! i never use aggr, that was my fail.)

Thank one more time!!!