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
Userlevel 6
- Looker Staff
- 213 replies
-
23 August 2018
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.