By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Quicksight working with calculated fields & percentages

0

Hi, I have the following dataset and I am really struggling to find the right calculation to get the result I am looking for:-

issueIdteammonthYearworkCategorypoints
ME-44846TeamAApr-2023Engineering3
ME-45314TeamAApr-2023BAU4
ME-45739TeamAApr-2023Engineering3
ME-43757TeamADec-2022Engineering3
ME-43760TeamADec-2022BAU3
ME-43762TeamADec-2022BAU2
ME-44256TeamADec-2022BAU2
ME-44257TeamBApr-2023BAU2
ME-44331TeamBApr-2023Engineering3
ME-44571TeamBApr-2023Engineering3
ME-44583TeamBApr-2023BAU2
ME-44816TeamBDec-2022BAU2
ME-44830TeamBDec-2022BAU2
ME-44832TeamBDec-2022BAU2
ME-44835TeamBDec-2022Engineering0

I have a calculated field (sum(max({points},[{issueId}))) which sums the points per team. But I actually want to convert the points into a percentage based on the workCategory, team and month. ie Team A in Apr-2003 spent 60% BAU/40% Engineering which I can plot on a graph with the month as the x-axis.

I'd then like to sum the averages across teams to get a total percentage split on Engineering/BAU.

Is this even possible?

Topics
Analytics
Tags
Amazon QuickSight
Language
English
mikeee
asked a year ago74 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content