Display a zero value
How do I display a zero value for a location which has no data. I have 7 locations with only 6 displaying because the 7th location has no data. How do I get the location to display in the table an show a 0% value?
Best Answers
-
You would need to create the zero entry in an ETL. You could do this with a join tile so that every location has a row for each type of value you want to report on.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
In the etl perhaps you could use an add formula file and name the column name then in the formula write this….
IFNULL(column name, 0)
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0
Answers
-
You would need to create the zero entry in an ETL. You could do this with a join tile so that every location has a row for each type of value you want to report on.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
In the etl perhaps you could use an add formula file and name the column name then in the formula write this….
IFNULL(column name, 0)
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
Hi Mark,
I have successfully created the column and the column with a zero value is appearing.
I had an issue. The percentage count was not a distinct count e.g. I then created a a beast mode calculation - COUNT(DISTINCT(CASE WHEN
Hierarchy of Control_Elimination count
= 1 thenParent Record: Uniq ID
END))This gave the percentage. However, when I untick the 'Show Totals' to stop showing the Grand Total via properties, Total Row my calculation changes. Do you know why?
0 -
Hi Mark, worked a solution. Instead of showing the value as a % of Total column in the formating of the calculation I edited the beast mode calculation -
COUNT(DISTINCT(CASE WHEN
Hierarchy of Control_Elimination count
= 1 thenParent Record: Uniq ID
END)) / COUNT(DISTINCTParent Record: Uniq ID
) * 100Thank you all for your assistance.
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
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 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
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive