Hello Community,
I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:
Within “Analysis” the table component has the function “calculate share in percentages”.
Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.
How does it work in the new views?
Thank you so much for help.
Best, Thomas
Hi Thomas,
In the new Views, the “Calculate share in percentage” option is not directly supported. However, you can achieve the same functionality using PQL.
1. After adding the Table component to your View, add a new column.
2. Use the following PQL expression to calculate the percentage share:
SUM("table"."column") / GLOBAL(SUM("table"."column"))To display the result as a percentage, make sure to change the format of the column to Percentage (%).
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.