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
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有