Hi,
I'm sure this is possible with a simple solution, but for some reason my brain won't work properly today :D
I have an aggregate model, and there's a grouping on it (field: status)
I want to find a way to show what % of grand total each 'group' represents
So as per example SS below , there's a total of 73 records
and i want each line (or group) to show % of grand total (73) it represents
So 1st line (approved) would show 48% ...
Any simple way to accomplish this?
Thank you
I'm sure this is possible with a simple solution, but for some reason my brain won't work properly today :D
I have an aggregate model, and there's a grouping on it (field: status)
I want to find a way to show what % of grand total each 'group' represents
So as per example SS below , there's a total of 73 records
and i want each line (or group) to show % of grand total (73) it represents
So 1st line (approved) would show 48% ...
Any simple way to accomplish this?
Thank you
 5,600 Points
Posted 2 years ago
Stephen Sells, Official Rep
 17,264 Points
I think it's just one of those days Dave.
I was able to build this pretty simply:
I made two models.
The first model was an aggregate counting the sum total of the albums.
The second model was an aggregate counting the sum total of the albums grouped together by Genre Name.
Then I created a UI Only field on the second model that used global merge syntax in a formula field to pull the '60' album count. The formula was pretty simple. I'm fairly certain there are other ways that could accomplish this, but I like this one.
Thanks for bringing this up. Let me know if you have any questions on the build.
I was able to build this pretty simply:
I made two models.
The first model was an aggregate counting the sum total of the albums.
The second model was an aggregate counting the sum total of the albums grouped together by Genre Name.
Then I created a UI Only field on the second model that used global merge syntax in a formula field to pull the '60' album count. The formula was pretty simple. I'm fairly certain there are other ways that could accomplish this, but I like this one.
Thanks for bringing this up. Let me know if you have any questions on the build.
Stephen Sells, Official Rep
 17,264 Points
You could put the entire formula in the function ROUND() if you wanted whole percentage points. That might be prettier.
Maybe add + '%' to the end in order for it to look extra purdy.
Maybe add + '%' to the end in order for it to look extra purdy.
 5,600 Points
That's perfect Stephen, I tried something similar , but see i messed up on syntax on global merge syntax from other agg model :D
Thank you very much will test it shortly :)
Thank you very much will test it shortly :)
Stephen Sells, Official Rep
 17,264 Points
 160 Points
I have setup a column chart with a series (by month) showing up to four stacked values per month. The values are meant to be the "percent of total" scenario mentioned here. The totals are never coming up correct and the reason is eluding me. Has anyone else every gotten this to work in this fashion (versus the table scenario mentioned above)?
Here is a quick pic of the scenario and the formula I am using with the two aggregate models...
Here is a quick pic of the scenario and the formula I am using with the two aggregate models...
 160 Points
btw, the numbers on the right are the actual counts that should be used to calculate the percent of total... for instance the '53' in the first column should be 38.5%
Matt Sones, Champion
 31,642 Points
Neil,
The problem here is that you need a different total for each month. I'm guessing your TestForSquidTotal model is just getting the total all the data, not the total for each month? Or if it is getting month, you're only getting the first month (row 0).
The problem here is that you need a different total for each month. I'm guessing your TestForSquidTotal model is just getting the total all the data, not the total for each month? Or if it is getting month, you're only getting the first month (row 0).
 160 Points
Ya, thanks Matt.... Is there a squid formula/syntax guide? I expect there is one ?
Related Categories

Tables and Filters
 242 Conversations
 229 Followers

Models and Model Conditions
 38 Conversations
 61 Followers

Skuid on Salesforce
 2230 Conversations
 176 Followers