Bug?: Running Total zero value missing bar
Hi Dojo,
Has anyone else experianced the following?
On a running total card, if a period has no data to add to the total the bar is missing for that period.
Here is an example, we have a 30 day running total bar chart where on the 16th day no data exists to add to the total.
This should display the same bar value as the previous day, however given there is no data no bar is shown.
I assume this is a bug somewhere in the calculations, am guessing logically the day value is retrived and added to the running total, however if the day value is zero or null the calculation breaks out of the function. might consider flipping this to get the running total first and then add the day value, or if null then 0, calculate.
Anyways, fyi, please review, thanks.
Rgds,
K.
Comments
-
Hi Dojo,
Is this issue being reviewed?
Now I've got a second missing bar, there should be no missing bars on a running total unless value is zero at intial previous day 30 and subsequent rolling zero days...
Many thanks.
Rgds,
K.
1 -
In case this is still an issue...You probably have null values...which Domo HATES!!! Since it's a running total, just add a dummy set that adds a zero value for each period so that the thing has something to add to the previous total. That may do the trick.
Hope all is well!
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive