I want to calculate percentage from total in calculated field

[aat]

Hello,
With the below dataset in QuickSight, how could I produce a calculated field which will calculate the “Expected %” column in the expected result

annotationProjectName	annotationFileId	calc_module_name	VRA_STEP_Status
Proj1	id0001	ANNOTATION	AVAILABLE
Proj1	id0002	ANNOTATION	INPROGRESS
Proj1	id0003	ANNOTATION	ANNOTATED
Proj1	id0001	ANNOTATION	AVAILABLE
Proj1	id0004	ANNOTATION	AVAILABLE
Proj1	id0002	ANNOTATION	INPROGRESS
Proj1	id0005	ANNOTATION	INPROGRESS
Proj1	id0006	ANNOTATION	ANNOTATED
Proj1	id0007	REVIEW	ANNOTATED
Proj1	id0008	REVIEW	ANNOTATED
Proj1	id0009	REVIEW	AVAILABLE
Proj1	id0010	REVIEW	INPROGRESS
Proj2	id0001	ANNOTATION	AVAILABLE
Proj2	id0002	ANNOTATION	INPROGRESS
Proj2	id0006	ANNOTATION	ANNOTATED
Proj2	id0003	ANNOTATION	ANNOTATED
Proj2	id0004	ANNOTATION	AVAILABLE
Proj2	id0005	ANNOTATION	INPROGRESS
Proj2	id0006	ANNOTATION	ANNOTATED
Proj2	id0007	REVIEW	ANNOTATED
Proj2	id0008	REVIEW	ANNOTATED
Proj2	id0009	REVIEW	AVAILABLE
Proj2	id0010	REVIEW	INPROGRESS

Below would be the expected result:

annotationProjectName	calc_module_name	VRA_STEP_Status	Expected %
Proj1	ANNOTATION	AVAILABLE	30%
Proj1	ANNOTATION	INPROGRESS	30%
Proj1	ANNOTATION	ANNOTATED	20%
Proj1	REVIEW	ANNOTATED	20%
Proj1	REVIEW	AVAILABLE	10%
Proj1	REVIEW	INPROGRESS	10%
Proj2	ANNOTATION	AVAILABLE	20%
Proj2	ANNOTATION	INPROGRESS	20%
Proj2	ANNOTATION	ANNOTATED	30%
Proj2	REVIEW	ANNOTATED	20%
Proj2	REVIEW	AVAILABLE	10%
Proj2	REVIEW	INPROGRESS	10%

Thanks in advance for your help.

[Brett]

Hi @aat,
Adding a percentage should not be a problem. What are the factors that you would be using to determine the percentage? Depending on the values you are wanting to calculate the Expected % based on, I should be able to figure out a solution with a little more information.

Thank you!

[aat]

Hi @Brett
Thanks for your reply.
In the expected result, I first compute the unique combinations of annotationProjectName, calc_module_name, VRA_STEP_Status. Then I will calculate the percentage of each combination from the original dataset.
I hope that helps as further information.

[Brett]

Hi @aat,
Would you be able to put your information in Arena so that I can see the calculations creating the unique combinations and what else will be needed?

QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

[FeatureTile 11(2)] Watch this video for a 30 second intro to Arena. QuickSight Arena provides you with an embedded instance of QuickSight right within the QuickSight Community. Using Arena, you can: Explore creating QuickSight data visualization dashboards for free Publish dashboards to the Community Gallery to showcase your skills Include dashboards depicting your use case while posting questions in the Community Q&A Clone underlying analysis views of published dashboards in order …

Thank you!

[Brett]

Hi @aat,
It’s been awhile since we last heard from you. Are you still having issues with your initial request or were you able to find a work around? If you are still in need of assistance, please follow the above directions to create an Arena dashboard for us to view and assist!

If we do not hear back within the next 3 business days, I’ll go ahead and archive this topic.

Thank you!

[Brett]

Hi @aat,
Since we have not heard back, I’ll archive this topic. However, if you have additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!