Dual figures in the Summary Field with CONCAT
So i found the solution to get two different values in the summary field with CONCAT command. I have the following beast mode command
CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end), ' Today')
what it does is allows me to se a sum of values in the selected timerange AND the last day value. The problem is it works perfectly when I select any current timeperiod from the date selector dropdown, however if I select any previous period (previous month, day, year) I get the result "0"....
What am I doing wrong!? please help!
Best Answer
-
I think that this has to do with you when statement on your "today" part of the beast mode.
Try this:
CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', ifnull(max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end),0), ' Today')
But know that if the period that you select does not include today, then it will show 0 for "Today"
1
Answers
-
I think that this has to do with you when statement on your "today" part of the beast mode.
Try this:
CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', ifnull(max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end),0), ' Today')
But know that if the period that you select does not include today, then it will show 0 for "Today"
1 -
Thank you! this is a better approach that I had because in my command if I use a period that does not include today then the entire Summary Value is 0 but with your approach it only zero's out the today's value...
If I understand correctly that has to do with how DOMO looks at data sets and that selecting a date range effectively eliminates all values outside of that range for the purposes of Beast Mode Command... which is a strange way of doing it, but when you simply select the current value in the summary field it will find it regardless of the data range you select.... it seems like it is an oversight on DOMO's part and I can't help but wander if there is a workaround for it...
In any event thank you for your solution!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive