Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart where I show 3 expressions and where the Period (Months 1 to 12) is the dimension.
However for the current Year I have no data available yet (Null) for the future months wich results in the "Accumulation" in a flat line which I don't want to show. (see picture)
Can I add a condition in a way that for the current year it only shows the line for the selected periods for the current year and the full lines for the other 2
Thanks,
Guy
Hi Guy,
You can use a Set Analysis clause that only takes into account the past values and excludes the future ones.
Cheers
You can have a condition on that expression alone like -
if(date < today(), <expression>)
you can replace today() with the max date - if they are different.
Let me know if it works.
Thanks already, but I don't have an idea how to proceed. Assume that "Period" is my dimension.
Hi Rocky,
I used the next expression:
=if(Period<Num(Month(Today())), Sum( {$<[Fiscal Year]= {$(=max([Fiscal Year]))},Period= {'*'} >} [Gross Sales ] )) |
The calculation is correct but it doesn't change a thing to the line chart. Has this something to do with the fact that I use "Full accumulation". When I add a condition Null() or zero to my if-statement the complete line results in zero.
Is there maybe a way to format the line style as blank / invisible or set the the line color to blank ?
Kind regards,
Guy