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

Canioagain · August 2022

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

MarkSnodgrass · August 2022

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 · August 2022

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 · August 2022

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 · August 2022

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 · August 2022

@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 · August 2022

@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.

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

Best Answer

Answers

Categories