How to display column value in Smart Text without selecting filter value?

I have setup a dataflow which adds last updated date/s columns to a dataset because preceding dataflows run daily even though the true data update frequency is monthly or less.

I would like to show the value in this column in a smart text filter but the value will only appear where the smart text is inserted when the filter is applied. If I apply the filter to a current last updated date then next month, after the last updated date changes, the data will all be filtered out until the new filter last updated date value is selected.

Any ideas on how to get around this problem of dynamically and automatically surfacing last updated dates within a dashboard where you are joining multiple datasets with different update frequencies.

Comments