Is beast mode needed?

Hi Everyone,
I created a card that uses a date_time_start dimension along with a ticket count on a metric table. This card shows the number of tickets that have a scheduled dispatch showing date and time.
What we want to do is turn past tickets to red except for today's and we used the Last 7 days by hour but the date range.
Here is the table from Yesterday-1/28 and it shows tickets that have scheduled dates from the last 7 days but it also shows date-1/28 ( the screenshot was made yesterday and giving an example as we don't have any dispatches scheduled for today-1/29).
We want to have the dates- 1/22-1/26 turn red. Would this be a "Case, When, Then, End" SQL?
Any assistacne is greatly appreciated.
Best Answer
-
Hopefully the GOATs 🐐 can chime in, but here's what I'd do:
Use this CASE WHEN (you were on the right track thinking of using the CASE WHEN) to flag a date as before today:
CASE WHEN `
Date_Time_Start
` < CURDATE() THEN 'Older' ELSE 'Newer' ENDThis will create a new column that can signify whether the date is for a past ticket or not.
Next, you'll use Color Rules (see link below) to highlight the table row when the "Older/Newer" column is == Older
Let us know if this gets you where you need to go,
✅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"!
1
Answers
-
Hopefully the GOATs 🐐 can chime in, but here's what I'd do:
Use this CASE WHEN (you were on the right track thinking of using the CASE WHEN) to flag a date as before today:
CASE WHEN `
Date_Time_Start
` < CURDATE() THEN 'Older' ELSE 'Newer' ENDThis will create a new column that can signify whether the date is for a past ticket or not.
Next, you'll use Color Rules (see link below) to highlight the table row when the "Older/Newer" column is == Older
Let us know if this gets you where you need to go,
✅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"!
1 -
@Data_Devon Thank you for the assistance!
This is exactly what we were looking for! Thank you and have a great day!
1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 107 SQL DataFlows
- 648 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 775 Beast Mode
- 75 App Studio
- 43 Variables
- 734 Automate
- 186 Apps
- 471 APIs & Domo Developer
- 63 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 137 Manage
- 134 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive