Smart text format

Victoria_G1
Victoria_G1 Member
in Cards, Dashboards, Stories

Hello!

I have a question in regards to formatting smart text in dashboards. Currently I have a timestamp of which a date was last updated, but I only want to keep the date and get rid of the timestamp. Below is a screenshot:

image.png

Any advice?

Thanks!

Best Answer

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓

    There's only so much you can do with smart text, and even if you are to use the date of last refresh for the Dataset, that might not be the date/time of the latest entry. For things like this I'd do the formatting in a Textbox card, and work either from the _BATCH_LAST_RUN_ or the column that actually contains your data. Then you can use a beast mode like:

    CONCAT('Transactions reflected up to: ', DATE_FORMAT(MAX(MAX(`Date Column`) FIXED()),'%Y-%m-%d'))

    References: FIXED function, DATE_FORMAT

Answers

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓

    There's only so much you can do with smart text, and even if you are to use the date of last refresh for the Dataset, that might not be the date/time of the latest entry. For things like this I'd do the formatting in a Textbox card, and work either from the _BATCH_LAST_RUN_ or the column that actually contains your data. Then you can use a beast mode like:

    CONCAT('Transactions reflected up to: ', DATE_FORMAT(MAX(MAX(`Date Column`) FIXED()),'%Y-%m-%d'))

    References: FIXED function, DATE_FORMAT

Categories