Skip to content

    • Cards, Dashboards, Stories

    Cards, Dashboards, Stories

    Dynamic Date in card tittle

    Member
    edited November 2024 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!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • 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.
    • Coach
      Answer ✓

      Try this:

      CONCAT('<span style="font-size:10px;">Data as of ', MAX(Transaction Date),'</span>')

      **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

    • 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.
    • Member

      Hello coach @MarkSnodgrass this works, Thank you!

    • Member

      Hello Coach @MarkSnodgrass additional question, is there a way to change the font size of summary number? it is looking too big. I tried to check in the formatting options but no luck. Thanks!

      Screenshot 2024-11-23 at 8.59.18 AM.png
    • Coach

      You can add HTML/CSS in the beast mode and add color and control the sizing. A simple example would look like this:

      CONCAT('<span style="color:red;font-size:10px;">Vehicles</span><br />', SUM(Vehicles))

      One thing to note, you won't see the changes while you are editing in Analyzer. You will need to Save and Close in order to see the changes.

      **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.
    • Member

      Hello Coach @MarkSnodgrass

      I found this interesting: https://domo-support.domo.com/s/article/360043430093?language=en_US

      Screenshot 2024-11-24 at 4.48.39 PM.png

      This is my calculation in beastmode:

      Screenshot 2024-11-24 at 4.51.29 PM.png

      I can't figure out how to create a calculation in beastmode to change the "font size" with my existing calculation above. I am getting syntax error. Please help 😅 Thank you!

    • Coach
      Answer ✓

      Try this:

      CONCAT('<span style="font-size:10px;">Data as of ', MAX(Transaction Date),'</span>')

      **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.
    • Member

      Hello coach @MarkSnodgrass this works, Thank you!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories