Skip to main content

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!


Hello ​@Sakura Hayashi 

wow great - you made my day 😍

Thank you so much

Best Thomas


Reply