Make blanks 0s in Sumo pivot
In excel there is an option you can set on pivot tables to display 0 for null fields. Is there a simialr setting in Domo for Sumo charts?
Best Answer
-
I dont think there is an option in the pivot card to display zero if the value is null.
If your Product name does not change that much, you should be able to replicate the sumo card using table card. Use the [Created At] in the first column of the card and for the rest use a beast mode to do calculation for the product.
Here is the ex:
Option 1 : IFNULL(SUM(CASE WHEN Product = 'Altalink B8075' THEN 1 END),0)
OR
Option 2:
SUM(CASE WHEN Product = 'Altalink B8075' THEN 1 ELSE 0 END)
You can use the same logic for rest of the product name. As I said, Its not feasible if your product name changes or new one gets added frequently. But, If it relatively stays the same then this works fine. I have used for many reporting and it works like a charm.
Hope it helps!
1
Answers
-
Most likely in Excel you could do that, though I don't know how. In Domo you could use the isnull function in a beastmode.
IFNULL
Used in logical statements in which you want to specify a replacement for null values.
IFNULL('Values',0)
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
I dont think there is an option in the pivot card to display zero if the value is null.
If your Product name does not change that much, you should be able to replicate the sumo card using table card. Use the [Created At] in the first column of the card and for the rest use a beast mode to do calculation for the product.
Here is the ex:
Option 1 : IFNULL(SUM(CASE WHEN Product = 'Altalink B8075' THEN 1 END),0)
OR
Option 2:
SUM(CASE WHEN Product = 'Altalink B8075' THEN 1 ELSE 0 END)
You can use the same logic for rest of the product name. As I said, Its not feasible if your product name changes or new one gets added frequently. But, If it relatively stays the same then this works fine. I have used for many reporting and it works like a charm.
Hope it helps!
1 -
Thank you very much for the help
0 -
Great. Glad to Help!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive