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.

3 Likes

that worked, thank you!