Single Value Card - Footer use Todays Date mysql like a summary number?

Canioagain

I'm creating a card. In the footer can I put something that will reflect today's date?

MarkSnodgrass

Unfortunately, the header and footer only accept static text. You could leverage the smart text feature and have the date built into the title of the card.

MarkSnodgrass

Unfortunately, the header and footer only accept static text. You could leverage the smart text feature and have the date built into the title of the card.

Canioagain

I didn't think so either. Be nice to be able to do that, and use different colors.

I appreciate the alternative solution too.

Thank you

MichelleH

Hi @Canioagain, I don't think this is an option for the Single Value Gauge. I suggest trying a Dynamic Textbox card instead: https://domohelp.domo.com/hc/en-us/articles/360042924514-Dynamic-Textbox

jaeW_at_Onyx

@Canioagain , if you build the date the data was collected into the dataset, maybe you can use a smart text, https://domohelp.domo.com/hc/en-us/articles/4529227357975-Using-Smart-Text

i would strongly urge you to avoid trying to use today() in your card title because IF there was a hiccup in your pipeline and the data hadn't been updated, you'd be misrepresenting the truth. if you build report_date = today() into your ETL, then the timestamp would be as of the last execution time which would always be accurate.

Canioagain

@jaeW_at_Onyx thank you for the suggestion. Definitely not going to put that in the footer :) that was just to help folks visual what I was trying to do.