Beastmode calculation error dividing
I'm trying to create a BeastMode that will give me 'average views per user'.
(tool 1 views + tool 2 views) / total users = average views per user
CONCAT (
(sum(`Tool 1 Views`)+Sum(`Tool 2 Views`) / (SUM(`Total Users`)))
,'Views')
My issue is that it VALIDATES the code but then gives me the following error: "An issue has occurred during processing. We are unable to complete the request at this time". I know the numerator executes correctly and the denominator executes correctly. Just not when I divide them
Anyone know any potential fixes?
Tagged:
0
Comments
-
CONCAT (
(sum(`Tool 1 Views`)+Sum(`Tool 2 Views`)) / (SUM(`Total Users`))
,' Views')Try this
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________1 -
If that doesn't work, you could try this:
case when sum(`Total Users`)=0 then 0 else
CONCAT (
(sum(`Tool 1 Views`)+Sum(`Tool 2 Views`)) / (SUM(`Total Users`))
,' Views')
END
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有