Beast Mode % of the total in Chart
I want to create a calculated value that show the % of the total. I have done this:
SUM(Case WHEN `Country` LIKE '%In' then `Value` ELSE 0 END)
/
SUM(Case WHEN `Country` = 'TotalIns' then `Value` ELSE 0 END)
But it displays anything although the formula is correct. I tried using only the first part of the formula and it works, I don't understand what's wrong.
Best Answer

Have you tried just the denominator (second part) and see what that returns? Based on your formula I'm assuming you have another row in your table which has the overall total, is that correct?
You could also attempt to do a windowed function (assuming you have them enabled in your instance  if not talk to your CSM to get them enabled).
SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END) / SUM(SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END)) OVER ()
Edit: Late night Dojo surfing = poor code. As @jaeW_at_Onyx mentioned you need sum(sum(...)). The code has been updated to reflect the correct syntax.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers

Have you tried just the denominator (second part) and see what that returns? Based on your formula I'm assuming you have another row in your table which has the overall total, is that correct?
You could also attempt to do a windowed function (assuming you have them enabled in your instance  if not talk to your CSM to get them enabled).
SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END) / SUM(SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END)) OVER ()
Edit: Late night Dojo surfing = poor code. As @jaeW_at_Onyx mentioned you need sum(sum(...)). The code has been updated to reflect the correct syntax.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
Sorry @GrantSmith ? i know you're gunning for that belt ?
SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END) / SUM(CASE WHEN `Country` LIKE '%In' THEN `Value` ELSE 0 END) OVER ()
to get to work in Domo, the denominator would have to be:
sum(sum( case ... end )) over ()
@nat040711 , if you haven't seen windowed functions before, I did a tutorial using LAG and LEAD, but SUM(SUM()) over is covered as well.
https://www.youtube.com/watch?v=cnc6gMKZ9R8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=23&t=1s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 284 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 570 Datasets
 2K Magic ETL
 3.4K Visualize
 2.4K Charting
 604 Beast Mode
 15 App Studio
 29 Variables
 601 Automate
 152 Apps
 418 APIs & Domo Developer
 29 Workflows
 2 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 365 Distribute
 99 Domo Everywhere
 264 Scheduled Reports
 2 Software Integrations
 98 Manage
 95 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive