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?
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
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.
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??
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.
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.
Our next major version will be released in January and we will look to include the plugin upgrade then. I will report back.
Thank you for your response. We will be looking forward to hearing from you!