Dynamic Text on Dashboard textbox?
Hello All,
Trying to add some dynamic descriptive text to my dashboard and not sure if this is possible.
I want to put the dynamic verbiage "increased" or "decreased" depending on the percent change of my metric of the given timeframe.
Is it possible to display this sort of dynamic text as a summary number in a dashboard text box?
Any help is appreciated.
Best Answer
-
Hi @user007486
You can utilize a beast mode to dynamically generate some text. If you're wanting to utilize this text as a summary number then you must use an aggregate function (sum, count etc). Beast modes without an aggregate function are not supported as summary numbers.
Assuming you have a value and target columns the following would work on a row level:
CASE WHEN `value` > `target` then 'Increase' WHEN `value` < `target` then 'Decrease' ELSE 'Same' END
To use it as a summary number (your logic will vary):
CASE WHEN SUM(`value`) > SUM(`target`) then 'Increase' WHEN SUM(`value`) < SUM(`target`) then 'Decrease' ELSE 'Same' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Answers
-
Hi @user007486
You can utilize a beast mode to dynamically generate some text. If you're wanting to utilize this text as a summary number then you must use an aggregate function (sum, count etc). Beast modes without an aggregate function are not supported as summary numbers.
Assuming you have a value and target columns the following would work on a row level:
CASE WHEN `value` > `target` then 'Increase' WHEN `value` < `target` then 'Decrease' ELSE 'Same' END
To use it as a summary number (your logic will vary):
CASE WHEN SUM(`value`) > SUM(`target`) then 'Increase' WHEN SUM(`value`) < SUM(`target`) then 'Decrease' ELSE 'Same' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
Ok that seems to work. I guess I just need to make sure I get my beast mode calculations correct in order to avoid the display errors. thank you, sir!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive