Count cases by number of events

[sergio0592]

Hi all,

I'd like to reach something but it doesn't works. I have a chart with a Key_ID (dimension) and an expression (=sum(NB_EVENTS)). I want get a count of cases (count Key_ID) for each value expression.

See pictures below:

Expected:

Thanks for your answers

Regards

[swuehl · Accepted solution]

Use a calculated dimension in a straight table chart:

=Aggr( Sum(NB_EVENTS), KEY_ID)

and as expression

=Count(DISTINCT KEY_ID)

[sergio0592]

It works perfectly!! A great thanks to you.