I am trying to work on rolling month Task in my dashboard.

[#1]

Hello Everyone,

I am trying to work on rolling month Task in my dashboard.In which if i am selecting any month then a bar chart will display the last 3 month's 3-3 weeks data ,

Can anyone tell me what approach i should use,

Thanks and Regards.

[#2]

Hello,

You can get the rolling months like below: Replace YourDate with valid date

Variables:

1) vMaxSelectedCalendarDate=MonthStart(max(YourDate))

2) vLastThreeMonths = =addmonths(vMaxSelectedCalendarDate,-3)

Then you can use these in set analysis expression

count({<[YourDate] = {">=$(vLastThreeMonths)<$(vMaxSelectedCalendarDate)"},[Trade Month]=,[Trade Year]=,[Trade Quarter]=>}itemid)

Thanks,

Angad