Start chart at first non-zero value

[evansabres]

I have a chart that has a dimension of date and an expression of orders. There are many dates that have a zero value for orders. The application is also built to make a selection first before viewing the chart. (The user makes a selection from a drop-down) After the user makes the selection, I want the chart to start at the first non-zero value as opposed to just the first date in the data set. Is that possible?

[ogautier62]

Hi

change your dimension as :

something like this :

if(DateOrder >= FirstSortedValue(total DateOrder,if( aggr(sum(expression order),Order>0,DateOrder)), DateOrder)

regards

[PrashantSangle]

can you explain with sample data? or screen shot of current output and required output.

regards,

[evansabres]

my fields are:

Dimension: DTE

Metric: TotalOrderValue

In your example, DateOrder would be the dimension? Expression order would be TotalOrderValue?

[balabhaskarqlik]

Try some thing like this:

=Max({< DTE={"<=$(=vEndDate)"}>} aggr(firstsortedvalue (Orders, -DTE), Orders))

Add some fields in this expression...

[ogautier62]

yes Dateorder would be DTE,

and expression order : TotalOrderValue

regards