Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys
In a dashboard graph i need to show figures for the last two years (within the selection) ascending, meaning for today() the graph will show 2008 and 2009 (in that order).
With a sort by ascending on the Year I can achieve this on a 2 year selection, but of course not with no selection at all (as it will show the last 2 years).
Is there any way so solve this?
Im running 8.5
Hi,
see the attached example for help.
Play with the "Set Analysis" expression and see the results.
Another example are this one (three month period):
Sum ( {< OrderDate={">=$(=addmonths(monthstart(max(OrderDate)),-2)) <=$(=addmonths(monthend(max(OrderDate)),0))"}>} Amount)
Good luck!
Rainer