Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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