Set Analysis + Alternate State + Filter Selection

calvintang — Fri, 30 Sep 2022 02:38:49 GMT

I have two alternate states: C1 and C2.

I have two filters, both of which use the same dimension: [Sold Month Year] - which is a monthname([Sold Date]) in the data load editor. I apply C1 and C2 to the filters even though they are the same dimension.

When I filter C1, I choose Sep 2021, Oct 2021, and Nov 2021.

When I filter C2, I choose Dec 2021, Jan 2022, and Feb 2022.

I am trying to count the number of tickets like this:

SUM({"C2" <[transaction_type]={'PAYMENT'}>} Ticket_Cnt)

But I want the calculated measure to only get me the minimum (or earliest month) - which is Dec 2021 figures only.

How do I ensure that the measure takes into account for the selection?

I have tried this:

SUM({"C2" <[trans_type]={'PAYMENT'}, [Sold Month Year] = {"MONTHNAME(=DATE(Min([Transaction Month Year]),'MMM YYYY'))"} >} txn_cnt)

But it does not work.

Not sure what I can do - can anyone assist?

Re: Set Analysis + Alternate State + Filter Selection

calvintang — Fri, 30 Sep 2022 02:42:54 GMT

SUM({"C2" <[trans_type]={'PAYMENT'}, [Sold Month Year] = {"MONTHNAME(=DATE(Min([Sold Month Year]),'MMM YYYY'))"} >} txn_cnt)

Sorry, I meant I tried this ^ and it did not work.

Re: Set Analysis + Alternate State + Filter Selection

calvintang — Fri, 30 Sep 2022 03:48:28 GMT

Solved it!

MIN(AGGR(SUM({"C2"<[trans_type]={'PAYMENT'}>} txn_cnt),[Transaction Month Year]),)

topic Set Analysis + Alternate State + Filter Selection in App Development

Set Analysis + Alternate State + Filter Selection

Re: Set Analysis + Alternate State + Filter Selection

Re: Set Analysis + Alternate State + Filter Selection