Question

Running Total - Day over Day - Hourly

  • 23 August 2018
  • 2 replies
  • 97 views

I’m tracking hourly data and comparing day over day running total in a pivot. I want the pivot/chart to stop at the last recorded hour of the current day. Any ideas?




Thanks,

K


2 replies

Userlevel 6
Badge

You can do this by wrapping the running total function in an if(...), testing the column you are totaling for a value.


if(${order_items.total_sale_price} >0,running_total(${order_items.total_sale_price}),null)


That worked and was too easy. Much appreciated.


-K

Reply