Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to restrict the dates on my Y axis to a range on my line chart.
Attached is my graph. If I want the dates from 10/4/2014 to 1/2/2015 only, how to achieve it?
In the sample below i use a sum( if() ) to only show the expression values that have a date higher than the a set date.
The top chart is all dates, the bottom is filtered in this way.
The expression is as follows: sum( if( Date >= date(makedate(2009,06,15)), Sales))
You would have to do the if condition on all expressions.