Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

% of grand total is giving wrong values

Answered
Chris Anderson asked on November 18, 2020

Hi there,
Please see attached.
When I try to show my column as a %, I’m getting the wrong values. For example, rows 2 and 6 in the screenshot. I’ve also attached a spreadsheet using the exported values.
Please could you advise what is wrong here?
Many Thanks

Attachments:
pivot (4).xlsx
Charts.png

6 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 19, 2020

Hello, Chris,
 
Thank you for reaching out to us.
 
We want to explain that Flexmonster always performs “% of Grand Total” aggregation over values summarized by the first available aggregation (“sum” for numeric measures).
In its turn, Excel differs “summarize by” and “show as” aggregations as demonstrated in your example. As a result, it displays percent of the grand total based on values summarized by “count” aggregation.
 
As a workaround, we suggest limiting the list of aggregations available for the “collection_id|collection_id_DD” field so that the “count” aggregation appears first.
The most convenient way is to define the type of this field as string.
We suggest checking out the JSFiddle demonstrating this approach.
 
Please let us know if it works for you.
Feel free to contact us in case further questions arise.
 
Kind regards,
Illia

Public
Chris Anderson November 19, 2020

Hi Illia,
Limiting the aggregations isn’t an option in our implementation, sorry
My actual requirement is represent the count of a string field as a % overall. Is this possible?
For string field, the only aggregation is Count and Distinct Count, so I can’t choose “% of grand total”. Also, if I try and format the column as a percentage is just multiplies the values by 100.
Please see the attached doc with screenshots. Is there anyway of me representing this with percentages bearing in mind the limitations you’ve mentioned? Surely this is a key feature lots of people need?
Even if you have a workaround using calc fields??
Thanks

Attachments:
Pie Chart.docx

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 20, 2020

Hello,
 
Thank you for your feedback.
 
Our team would like to explain that “% of Grand Total” aggregation is available for the string data type in the component’s latest releases.
In case only “count” and “distinct count” aggregations are available for string data type in your case, we suggest updating Flexmonster to the latest version. Here is our updating to the latest version tutorial for guidance.
 
Concerning the formatting, the percentage symbol will be added to values automatically after selecting “% of Grand Total” aggregation.
 
We suggest seeing the JSFiddle that demonstrates the described approach for a reference.
 
Please let us know if it helps.
Feel free to contact us in case additional questions appear.
 
Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 5 days ago

Hello, Chris,
 
We would like to ask whether you had some time to test the described approach on the latest version.
 
Our team is looking forward to hearing your feedback.
 
Kind regards,
Illia

Public
Chris Anderson 4 days ago

Hey Illia,
 
Our next major version will be released in January and we will look to include the plugin upgrade then. I will report back.
 
Many Thanks

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 4 days ago

Hello, Chris,
 
Thank you for your response. We will be looking forward to hearing from you!
 
Regards,
Illia

Please login or Register to Submit Answer