How to get single value viz to report last value of running total

[molly_lippsett]

Knowledge Drop

Last tested: Apr 8, 2020
 

Say you have a running total table calc on a dataset that's sorted by date in ascending fashion. You want to grab the value of the last row of the running total column (value for the most recent date).

To do this, we can create a new table calc if(row()=max(row()),yes,no), then select “Hide No’s from Visualization”. All of the rows except for the last row will be marked “no”, so the single value viz will pick up the latest date.

This content is subject to limited support.