Calculated Field in Visuals
Hi,
I have created a calculated field (a percentage) and have formatted it as such in Quicksight. However, when I add this to a donut chart and choose 'Add Metric' it just shows as the value 0.095 for example and not 9.5% which is incredibly frustrating . Is there a way to format this as its % value and not the numerical value. Please note i am aware of "value and percent" but that percent is of the total, not the calculation.
Thank you for posting the question and the detailed explanation on what you are expecting. At present, it is not possible to format the value as percentage in the Donut chart and this is an expected behavior. As every slice already represents a percent of the total, so we do not format individual values as percentages additionally, to avoid confusion. However, to achieve your use case you can consider the below workaround:
- Create a calculated field with expression {column_name} * 100 where column_name is the column which has the values like 0.095
- On the analyses page add this calculated field to the Donut chart and choose “Add Metric”.
- Then navigate to “Field wells” > click on the calculated field > Format >More Formatting Options..
- In “More Formatting Options”, navigate to “Units” and add a '%' suffix manually.
Following the above steps you should be able to display the values as percentage in the Donut chart.
Relevant questions
Calculated Field in Visuals
asked 5 months agoHelp with Quicksight Calculated Field for Timeseries aggregate Values
asked 2 months agoQuicksight - Using calculated field in visualizations
asked 6 months agoQuickSight calculated field: How to get sum of last values of timestream measures
asked 4 months agoHow to add a CNAME without Root Access?
Accepted Answerasked 3 years agoYoY and MoM metrics up to certain day of year or month in QuickSight
asked 8 months agoHow to make a Year-Over-Year Line Chart in QuickSight
asked 5 months agoCan you edit the data in an Amazon QuickSight dashboard after it's published?
Accepted Answerasked 2 years agoBest way to have a snapshot-based QuickSight histogram
asked 2 months agoIfElse Calculated Field not Working
asked 5 months ago