Cards work well all day but suddenly show "No Data Exists"
Hello, Im new working with domo and I have this issue with some of my cards that are not showing data even when they use the exact same dataset of the others that actuallty shows data. All cards works well during morning and afternoon, but the stop wporking 20:00hrs app, I check the schedule and it is set to reaload each 15min with no hour limitation. Is there any SQL connector known issue? Plase Help Regards Matias
0
Comments
-
Hey @user09729,
Are you doing any calculation [especially division] in beast mode for the visualization. If that the case, it might be caused by the zero issue. This can be avoided by using nullif statement in numerator.
For ex:
SUM(CASE WHEN X = 'X' THEN `Duration of Call` END ) /
NULLIF(COUNT(CASE WHEN X = 'X' THEN `Date Called` END),0)Hope this helps
1
This discussion has been closed.
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 820 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive