Custom Summary Number Not Cleanly Exportable to Powerpoint ?
When I found this Knowledge Base post (see link), I was excited to see that it is possible to create a custom summary number, especially to string together more than one metric...: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Card_Element_Transforms.
…however, I was disappointed by seeing this callout, which is a deal-breaker for us: “Important: The changes discussed in this section are not supported on Domo Mobile or when exporting to PowerPoint. In these cases, HTML will appear instead of the summary numbers. “
Has anyone come up with a way to override that callout…i.e., so that the custom summary number can export to PPT as formatted text (or a text string) without displaying html? Thanks!
Best Answers
-
One correction...I see that I can string two fields together, and that will export cleanly, if I don't use html for any additional formatting.
One additional quirk: It looks like I can't have a date field as a first or only field in the custom summary number. But, if I string a value field first, together with a date field second, then both will display correctly and cleanly concatenated together. Not sure why though. Anyway, hope that makes sense. Maybe this will be useful to someone else along with way, too.
0 -
I got confirmation that for the custom summary number to work, it has to be a value field, not a text field.
Here's what I figured out:
If you want to use a date alone as a summary number, I figured out a way to trick the system to recognize the date as a value with the following beast mode calc:
CONCAT( 'Latest Week Ending Date: ', MAX(YEAR(`Max_Date`))-1+1 , '-', MONTH(`Max_Date`), '-', DAY(`Max_Date`))
* Extract the year, then subtract "1" from it and then add "1" back. This makes it look like a value field.
Just thought I'd share in case anyone else was trying to do the same thing.
0
Answers
-
One correction...I see that I can string two fields together, and that will export cleanly, if I don't use html for any additional formatting.
One additional quirk: It looks like I can't have a date field as a first or only field in the custom summary number. But, if I string a value field first, together with a date field second, then both will display correctly and cleanly concatenated together. Not sure why though. Anyway, hope that makes sense. Maybe this will be useful to someone else along with way, too.
0 -
I got confirmation that for the custom summary number to work, it has to be a value field, not a text field.
Here's what I figured out:
If you want to use a date alone as a summary number, I figured out a way to trick the system to recognize the date as a value with the following beast mode calc:
CONCAT( 'Latest Week Ending Date: ', MAX(YEAR(`Max_Date`))-1+1 , '-', MONTH(`Max_Date`), '-', DAY(`Max_Date`))
* Extract the year, then subtract "1" from it and then add "1" back. This makes it look like a value field.
Just thought I'd share in case anyone else was trying to do the same thing.
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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 689 Automate
- 177 Apps
- 454 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive