topic Visualization | Issue in Showing MOM Trend Result in App Development

Visualization | Issue in Showing MOM Trend Result

sravankv — Tue, 30 Nov 2021 16:25:32 GMT

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:

Appreciate your support and Thanks in advance..

chrismarlow — Mon, 29 Nov 2021 19:43:34 GMT

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 — Tue, 30 Nov 2021 04:14:45 GMT

@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))