Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a line chart that graphs the accumulated (running sum) of daily sales. I have used this expression which I found in this community (thanks):
Sum(Aggr(RangeSum(Above(Sum(this_year_daily_total), 0, RowNo())) , day))
I would like the line to end when there are no more values to accumulate, i.e. when the chart reaches the 'current' day. I guess I would need to use the Below() function but I am not sure how to evaluate till the end of the month. Also is it possible to stop the line being drawn?
In the attached image, the arrows points to where I would like the line to stop.
The data contain rows:
Month, Day, Product, ValueSold
The values for all products are summed for each day and accumulated for each day and each month.
if(day <= day(today()), Sum(Aggr(RangeSum(Above(Sum(this_year_daily_total), 0, RowNo())), day)), null())
if(day <= day(today()), Sum(Aggr(RangeSum(Above(Sum(this_year_daily_total), 0, RowNo())), day)), null())
Very nice! The solution is exactly what I wanted. Thank you.