Dashboard not displaying Zero Sum results
I've built a dashboard for a variety of Adwords and Bing Ad results, and everything is working smoothly besides when I filter specific timeframes and the summation is zero, wherein it doesn't display anything in the Single Value field. I've created the following piece of code to try to mediate the issue and it doesn't seem to be working:
Case When
Sum(`Phone Conversions`) < 1
then 'zero'
else Sum(`Phone Conversions`)
END
Additionally, I use the 'Phone Conversions' field in another equation as the amount being subtracted, and it seems like when this piece of data is zero, the same thing happens wherein no data is shown in the Single Value field output, instead of showing the full value of the number that 'Phone Conversions' was being subtracted from.
I've ensured that each input of data is numerical and not text, so I'm not sure what the issue could be.
Any ideas?
Comments
-
Hello @user17856 ,
The issue in the current beastmode is a mix of datatype in the output of the CASE statement.
Case When
Sum(`Phone Conversions`) < 1
then 'zero'
else Sum(`Phone Conversions`)
END
The THEN statement produces a String value where the ELSE statement produces a number
You should be able to use: Case When
Sum(`Phone Conversions`) < 1
then 0
else Sum(`Phone Conversions`)
END**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.6K All Categories
- 1 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
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有