Exprsn

[smilingjohn]

HI Expertise

Please find the attachment of the QVW file.

currently i have the created date till OCTOBER 2017.

I want to show the 24 months back from max created date ...

But right now it is showing 2 years back ..

Actaully it whould from OCT-2017 back to 24 month-year..

What changes needs to be done to the dimesion ?

Thanks in advance

[sunny_talwar · Accepted solution]

Try this

Dimension

MonthName(Created)

Expression

Count({<Created = {"$(='>=' & TimeStamp(MonthStart(Max(Created), -24), 'DD-MM-YYYY hh:mm:ss') & '<' & TimeStamp(MonthStart(Max(Created), 1), 'DD-MM-YYYY hh:mm:ss'))"}>}Key)