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.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 58 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive