Display Max(date) in a Text Box or KPI

I’m new to QS and this seems like it should be simple, but I can’t figure it out.

So I have a column that has the TimeStamp the data was loaded into the snowflake warehouse my spice dataset loads from.

I want to display a box at the top of my sheet that says “Data is current as of MM/DD/YYYY” where MM/DD/YYYY is the most recent date in the data set.

I have a calculated field for Max Load Timestamp. It works in a Table view. But is there a place where I can put that in elsewhere? like in a KPI Box or as part of a text box or even an insight? I couldn’t figure out how to do that in any other way that might look a little bit “prettier”

You can do something like this.

Substitute the latest_refresh with your Max Load Timestamp.

Then you can create a maximum (or another calculation) but the maximum works and substitute in the Max Load Timestamp.

Then after that you can use this in the insight and it should work.


that worked, thank you!