Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Please see an example of data table I have.
I would like to convert the absolute counts in table 1 into percentages such that denominator is total count of all categories in each account as shown in table 2 below. Please help
Table 1 (Current Format)
Table 2 (Desired Format)
% Count within each account
You could use a flow like below:
First use a Group recipe to calculate the total count for each account:
Then use a Join Recipe between the output dataset of the Group recipe and the input dataset:
Add the calculated sum values to the dataset:
Then calculate the percentage in a post-join computed column of the join recipe:
After these steps the output dataset contains the corresponding percentages for each account:
Post a Question