line chart x axis restrict date value

Thu, 09 Oct 2014 18:38:25 GMT

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?

Re: line chart x axis restrict date value

JonnyPoole — Thu, 09 Oct 2014 19:04:00 GMT

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.