How to calculate other percentage in pie charts?
I have to create a pie chart in which one field calculation is like this
Sum(X) / Sum(Y) * 100
which is giving the value of a particular category ( M ).
Now I have to show other categories percentages like 100  ( % of M ).
How can I do this in beast mode or without beast mode using pie charts?
How can I show 0.65 in other categories?
Comments

What are your X and Y? Is Y constant across the entire dataset?
You could utilize a new beastmode to define a new category with a CASE statement and then use that as the Pie Name field
CASE WHEN `dayName` = 'Monday' THEN `dayName`
ELSE 'Other'
END**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 
X and Y both are numbers that vary by date range.
In your example, you used count here instead of counting I want some percentage calc
so my formula for Monday = Sum(X) / Sum(Y)
for Others 1  Sum(X) / Sum(Y)
So in this calc, I am getting the error.
If you have a solution for this scenario please share with your beast mode code.
0 
The Pie Chart automatically calculates the percentage based on the category label. Are you able to determine if a value is to be included in your X bucket or not? If so you can use that logic in a case statement to split out the X values into 'Other' and 'Not Other' buckets to graph how you're wanting.
Your math simplifies to SUM(NOT X) / SUM(Y) for the other grouping. So instead of thinking it like 1  SUM(x) / SUM(Y) thinnk of it in terms of X or Not X for your grouping.
This is assuming your dataset isn't summarized via a SUM before utilizing it in the pie chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 
My Dataset can not be summarized via a SUM before utilizing it in the pie chart because the pie chart will show dynamic values based on date selection filter on the dashboard.
In my dataset, there are four categories ( A, B, C, D) out of two ( B and C ) ( I am creating a pie chart for these two. ) are having calculations like SUM(X) / SUM(Y) in a column but others have SUM(X) only.
This calculation SUM(NOT X) / SUM(Y) and 1  SUM(X) / SUM(Y) is wrong in my case.
Business logic is like that we have taken only sum(x) / sum(y) which is a constant value on a particular date range selection.
then I have to put the remaining part of the percentage ( 1  SUM(X) / SUM(Y) ) in other categories.
I should not take Sum( not x ) in others' calculations it will give the wrong calculation.
so when I am doing the calculation for else part ( 1  sum(x) / sum(y) ).
It is taking x of ( A and D ) which is wrong.
for others calculation should be like this 1  Sum (X of B ) / Sum ( Y ) ( for pie chart of B )
0 
Do you have some example data you can provide (that's either safe to share or make your own obfuscated dataset as an example)?
I'm still a little perplexed with how your data is structured and what exactly you're asking about.
If you're doing a pie chart for just B then are you filtering for only B data on your card?.
Is Y for ALL data across A, B, C and D? Just B? Just B and C?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 298 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 616 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 729 Beast Mode
 54 App Studio
 40 Variables
 678 Automate
 173 Apps
 451 APIs & Domo Developer
 46 Workflows
 8 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 33 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive