Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
change your dimension as :
something like this :
if(DateOrder >= FirstSortedValue(total DateOrder,if( aggr(sum(expression order),Order>0,DateOrder)), DateOrder)
regards
can you explain with sample data? or screen shot of current output and required output.
regards,
my fields are:
Dimension: DTE
Metric: TotalOrderValue
In your example, DateOrder would be the dimension? Expression order would be TotalOrderValue?
Try some thing like this:
=Max({< DTE={"<=$(=vEndDate)"}>} aggr(firstsortedvalue (Orders, -DTE), Orders))
Add some fields in this expression...
yes Dateorder would be DTE,
and expression order : TotalOrderValue
regards