Set Analysis + how to write + store with any transaction withn 3 months

[jim_chan]

hi guys,

i want to know how to write a set analysis that see number of stores that has any transacation withn 3 months.

for exmaple: i have selected i have select month - January 2017, so it should list out stores that has transaction within this 3 months jan 2017, dec 2016 and nov 2016.

how to write???

Rgds

Jim,

[asgardd2]

Hello!

I think you can :

     1. Create variable ( current selection of field "month"  or "date", for ex. Concat(Date)) . Or you can create another var , like this :

yourVariable = '>=' & MonthStart(AddMonths(date,-2)) & '<=' & Concat(Date)

     2. Use this variable in set analysis, like this: {<date = {$(yourVariable)} >}

Please, attach example file.

P.S. You must turn on option - only one selected value in object properties.