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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive