Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Happy Monday everyone.
I'm hoping this will be a simple calculation, but can't see to get this working (even with set analysis)
I've a chart created using Set analysis, showing a rolling 12 months of data.
Each month, this will automatically update to show the latest 12 months.
So in my title i simply want it to say Aug for example
So i created a variable to show max month.
=month(max(Timelines.Period_Start_Date)) which in this example will come back and show Aug
However, when i then select say Feb from a list of available months... the title updates to Feb.
How can I get this to stand alone in an expression;
Thanks for your time.
If your selection is on Timelines.Period_Start_Date, then add the condition as shown below. This will ignore the date selection
month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))
If your selection is on Timelines.Period_Start_Date, then add the condition as shown below. This will ignore the date selection
month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))
Excellent, that's exactly what I wanted and works a treat.
Thank you for your time
Hi,
You can use this.
month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))