Smart Text Date ranges

JoeS
JoeS Member
in Cards, Dashboards, Stories

I have a dashboard with 3 tables in it: current week, previous week, and historical week. The historical week is controlled by a 'week #' slicer.

I am trying to display the week number and date range in each card title. for example the table titles should show "Current week # 19, 5/4/25 - 5/10/25", "Previous week # 18, 4/27/25 - 5/3/25", and the historical table would show similar depending on what week is selected in the slicer.

The only part of this I can get working is the week number on the historical table, since that table is actually filtered on 'week #' otherwise they just say "All Time" or "This Week"/"Previous Week"

Any guidance would be great, also I'm pretty much brand new at DOMO

Tagged:

Answers

  • Data_Devon
    Data_Devon Contributor

    Hi JoeS, welcome to Domo!

    SmartText will be your best friend here. You can reference the dates that are filtered to then display in SmartText as a title for the Card. Depending on how your data is set up, you might need to do a BeastMode that will be referenced in the SmartText - but I can't make that conclusion without knowing more about your data.

    Check out the KB pasted below for guidance:

    https://domo-support.domo.com/s/article/4529227357975?language=en_US

    Once you get a chance to review that, let us know if you are on the right track.

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

  • JoeS
    JoeS Member

    Hi Data_Devon,

    I've been trying to use the SmartText, but what i was meaning is that the SmartText is just displaying "This Week" or "Previous Week" instead of actually putting in the dates.

    also, the historical table is being filtered by a week number slicer, the table that interacts with this slicer, will correctly say the week number selected but it also says "All Time" in the smart text. It does not seem to realize that the week number limits the date range. The data is displayed correctly but the SmartText is wrong.

  • Data_Devon
    Data_Devon Contributor

    In that case, you'll need to use SmartText to reference the filter that you want to display, which might just be a simple Date type column.

    You can reference the Filter via the SmartText:

    image.png

    I am not sure if this will quite get you where you need though so might need to call in the goats.

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

Categories