Cards work well all day but suddenly show "No Data Exists"
Options
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
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 575 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive