Dynamic Date in card tittle

Jez
Jez Member
edited November 22 in Cards, Dashboards, Stories

The objective is to add max date of "open date" column in the card tittle.

For example: Open date max date is 11/22/2024

My card tittle will be: "Opened Account as of 11/22/2024"

I am thinking to use beastmode and create a calculated field with "max(open date)" but when I'm using smart text function in the tittle to add this calculated field it won't work.

Any suggestion please? Thank you!

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Unfortunately, the smart text doesn't allow for that in the card title. I have utilized the summary number to display this information. You can create a beast mode that utilizes the CONCAT function and your MAX date to do it. Something like this:

    CONCAT('Open date max date is', MAX(opendate))

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Unfortunately, the smart text doesn't allow for that in the card title. I have utilized the summary number to display this information. You can create a beast mode that utilizes the CONCAT function and your MAX date to do it. Something like this:

    CONCAT('Open date max date is', MAX(opendate))

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Jez
    Jez Member

    Hello coach @MarkSnodgrass this works, Thank you!

Categories