Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called DispLD, which represents the Load Date for file data.
I want to be able to show just the last 3 months based on this field. I have made an equation below in set analysis, which works, but is only showing the DispLD - 2. It is currently april, so the expression below shows results for February ONLY. I want to be able to show results for February, March and April.
DispLD = {'$(=Max(DispLD-2))'
DispLD is formatted as YYYYMM (i.e 201504 is April 2015)
Any help you can offer is appreciated.
DispLD = {'>=$(=Max(DispLD-2))'
DispLD = {'>=$(=Max(DispLD-2))'
Worked perfectly. Thank you for the quick response.
in a chart with DispLD as dimension
try expression
concat({$ <DispLD ={">=$(=date(addmonths(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),-2),'YYYYMM'))<=$(=date(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),'YYYYMM'))"}>} distinct DispLD , ' ')
DispLD = {'=date(=Max(DispLD-2),YYYYMM)'}