This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a query regarding the Group BY and Sum/Percentage calculation.
Scenario : I have a column having 100 values. The values can be First/Mid/Last. Now when I want to calulate the percentage of each of these values in the column, I can easily do that using Group By on the same column and then the Count of Each value divided by the total count of values.
The problem I am facing right now is, I have atleast 50 such column with same set of values (viz, First, Mid and Last). I want percentage of each value in the entire colulmn and I want to do it for all 50 columns. I dont want to do the same process for 50 different columns.
Is there any way to do it in the same node or any shorter process for that.