Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have spent ages looking at this and cant find a way to make it work. I have a number of graphs/tables i only want to show a set amount of months for (normally last 12)
Currently i am using this autocalendar function to display the month in my data:
[Inspection Logged-Notification Created Date.autoCalendar.YearMonth]
anyone got any ideas how to do this?
Hi Jgreen,
May be this:
Use this as your calculated dimension
If([Inspection Logged-Notification Created Date.autoCalendar.YearMonth] >= AddMonths(max([Inspection Logged-Notification Created Date.autoCalendar.YearMonth]), -12), Date)
Just make sure the format of the filed and Addmonths outcome is same.
Br,
KC
try this,
If([Inspection Logged-Notification Created Date.autoCalendar.YearMonth] >= AddMonths(max([Inspection Logged-Notification Created Date.autoCalendar.YearMonth]), -12), [Inspection Logged-Notification Created Date.autoCalendar.YearMonth])
Br,
KC
Hi Jgreen,
Can you please check what is the value your are getting when you put below expression in a text box ? The format of the expression should be same as your date field.
AddMonths(max([Inspection Logged-Notification Created Date.autoCalendar.Date]), -12)
if not, then simply add date( exp,'your date format') and give it a try.
Else please share a sample so it will be helpful to troubleshoot.
You can implement this logic after creating the master calendar.
Br,
KC