Text box is not populated by Beast Mode
So, I have a beast mode that generates a text block with some basic information about a helpdesk ticket dataset. Its purpose is just to let the user know how recent the data they're seeing is. In short, it tells (1) when the ETL was last run, and (2) the most recent ticket ID and date. Simple enough, I'd think.
If I add (1) the text is generated and the card works. If I add (2) nothing appears. There is no error message or overt indication of failure… there's just nothing there. Any suggestions what might be wrong? Here's the code of the beast mode:
CONCAT(
'SNOW Data Generated '
, DATE(Generation timestamp)
, ' at '
, HOUR(CONVERT_TZ(Generation timestamp,'+00:00','-05:00'))
, ':'
, RIGHT(LEFT(TIME(CONVERT_TZ(Generation timestamp,'+00:00','-05:00')),5),2)
, ' CDT\n'
, number
, ' is the most recent, opened on\n'
, DATE_FORMAT((opened_at), '%b %d %Y at %H:%i')
)
Best Answer
-
You need a way to select a single value. This beastmode will have a result for every row of data. I used your same beastmode but limited the card to 1 row of data and then sorted on the date field descending and the card worked as expected. You may have to do some ranking in ETL because you need the most recent of 2 different dates. If you had rankings you could use that for your sorting. You could also just add MAX() functions in your beastmode if you just need the most recent of each date.
If I solved your problem, please select "yes" above
2
Answers
-
You need a way to select a single value. This beastmode will have a result for every row of data. I used your same beastmode but limited the card to 1 row of data and then sorted on the date field descending and the card worked as expected. You may have to do some ranking in ETL because you need the most recent of 2 different dates. If you had rankings you could use that for your sorting. You could also just add MAX() functions in your beastmode if you just need the most recent of each date.
If I solved your problem, please select "yes" above
2 -
Apologies for not responding sooner. I had to move to another matter for a while. This worked. Thank you for the clear help.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 689 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive