set analysis + MTD Active Store but with conditions.

[jim_chan]

HI guys,

I need to create a MTD number of Active Store  bar chart.

So,

1st requirement - it has to be MTD.

2nd requirement -  An active store must with at least 1 sale transaction in last 30 days.

I have tried with set analysis as below:

Count{<CUS_ID={'=$(=Sum({<Date={'>=$(=Monthstart(Max(Date)-30)))<=$(=Max(Date)-30)))'}>}DEV_QTY)>=0)'}>}CUS_ID)

the above one is not working. no result, show nothing on bar chart.

the below one. i am just trying to count the CUS_ID where the sales(DEV_QTY) is not equal to 0.

Count({$<DEV_QTY -= {'0'},Date={">=$(=MonthStart(Date(Max(Date))))<=$(=Max(Date)-30)"}>}CUS_ID)

Rgds

Jim

[sunny_talwar]

May be this?

Count{<CUS_ID={"=Sum({<Date={'>=$(=Monthstart(Max(Date)-30)))<=$(=Max(Date)-30)))'}>}DEV_QTY) >= 0)"}>} CUS_ID)

But I don't know if this is going to work. Would you be able to share some sample data or a sample application to look at?

[jim_chan]

not working.

sample data........ok