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
⋅ 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
⋅ 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
⋅ 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
⋅ November 30, 2020
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
⋅ November 30, 2020
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
⋅ November 30, 2020
Hello, Chris,
Thank you for your response. We will be looking forward to hearing from you!
Regards,
Illia
⋅ February 1, 2021
Hello, Chris,
We are reaching out to ask if you had some time to check the latest version of the component.
If so, please let us know if the mentioned "% of Grand Total" works as expected for your case.
Our team is looking forward to hearing from you.
Kind regards,
Illia
⋅ February 1, 2021
Hey Illia,
We implemented this over the weekend and are happy to report that it fixed the issue.
Many Thanks
