topic Re: Counting dimension value when equal to max of another dimension. in App Development

Counting dimension value when equal to max of another dimension.

stascher — Sat, 16 Nov 2024 07:30:57 GMT

Given the following table:

I want to create a stacked bar chart where Event is one dimension, Severity is another

and the measure is a distinct count of Subjects experiencing each Event for a given Severity,

but ONLY if the Severity is the maximum severity that Subject ever experienced for the given Event.

I tried count( distinct aggr( if( max( Severity)=Severity, Subject),Subject)) but obviously it didn't work.

Thanks for any help,

Steve

sunny_talwar — Fri, 05 Oct 2018 16:48:27 GMT

How about this

Count(DISTINCT Aggr(If(Max(TOTAL <Event, Subject> Severity) = Severity, Subject), Subject, Event, Severity))

sunny_talwar — Fri, 05 Oct 2018 16:52:03 GMT

This is what I get

stascher — Fri, 05 Oct 2018 16:54:32 GMT

Knew I could count on you Sunny. Thanks much!