App Development

[sravankv]

Hi All,

I having a challenge to show MOM Count on Bar Chart.

Issue: Selected Month is showing correct Count. But, previous months are showing wrong result.

Ex:  I have 3 months data and i need to show count(distinct GID) where Count(distinct EID)>2.

Count(DISTINCT{<Month={"<=$(=max(Month))"},GID={"=count(distinct EID)>2"}>}GID)

when i used above query the result are 

instead of:  small correction 1, 1, 3(Jan: GID 200 is having 3 dif EID's, Feb: 200 is having 3 dif EID's and Mar: all 3 GID's  having 3 dif EID's.

I am not able to aggregate count's based on Month.

Sample Data:

Month	GID	EID
31/1/2021	100	101
31/1/2021	100	102
31/1/2021	200	201
31/1/2021	200	202
31/1/2021	200	203
28/2/2021	100	101
28/2/2021	100	102
28/2/2021	200	201
28/2/2021	200	202
28/2/2021	200	203
28/2/2021	300	301
28/2/2021	300	302
28/2/2021	300	302
30/3/2021	100	101
30/3/2021	100	102
30/3/2021	100	103
30/3/2021	100	104
30/3/2021	200	201
30/3/2021	200	202
30/3/2021	200	203
30/3/2021	200	204
30/3/2021	300	301
30/3/2021	300	302
30/3/2021	300	303
30/3/2021	300	304

Appreciate your support and Thanks in advance..

[chrismarlow]

Hi,

Any set analysis applies across all of the values by dimension,  so you can't filter differently by month like that.

I think you could try IF & AGGR similar to the below ... I don't know if you really need the max(Month) piece, but you can in theory combine;

Cheers,

Chris.

[sravankv]

@chrismarlow  Thanks for your response.

But, it's a trend chart and I have to show MoM comparison from the month selected to previous months.

So, that's the reason I used <=$(=max(Month))