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.