Filling blank cells with 0
I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports.
The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine.
Now, I'm trying to display 0 in these blank cells.
Initially, I used the property under General to fill empty cells with 0 value. But, this just fills 0 in the columns where I'm doing calculation as well.
I believe before empty cells are filled with 0 value, empty cells are ignored during calculation phase and hence after that, domo fill all empty cells with value 0.
I tried below formulas for calculated_count, but this also gave me the same result:
case when `count` is null then 0 else SUM(`count`) end
But none of them worked to give 0 in empty cells.
I've gone through multiple posts regarding this.
this suggests to use a case statement to filter out blank cells.
I added a calculated field, with formula:
CASE WHEN `count` IS NULL THEN 'Blank' ELSE 'Not Blank' END
After that, I added this field in filters section and when I try to see available options in newly created filter, I see only "Not Blank" coming. I was expecting two values: Blank and Not Blank
Not sure, if there's something that I'm missing out.
Let me know, if any other information needed from my side.
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 373 Beast Mode
- 20 Variables
- 176 Cards, Dashboards, Stories
- 484 Automate
- 102 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive