% of Total
Shumilex
⚪️
Hi,
I am currently working with a dataset with text values that I want to count and get the percent total.
I can do the count since Domo allows you to count text values, but I can't do the % total. I wanted to include another column that would give the sum of the count, then I would be able to do the % total.
I tried SUM(COUNT('typename') as well as 'typename'/ COUNT('typename') and none of those gave me the results I need.
0
Best Answer

Hi @Shumilex
You'll want to utilize a windowing function to calculate the sum for each partition / typename and then divide that by the sum of the entire dataset.
SUM(SUM(1)) OVER (PARTITION BY `typename`) / SUM(SUM(1)) OVER ()
If you don't have windowing functions enabled you'll need to talk with your CSM to get that feature switched on.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers

0
This discussion has been closed.
Categories
 10.7K 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
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有