How to arrive % for mulitple metrics

Question & Answer
, , , , , ,
1

image
image694×473 33.1 KB

Hi Team,
I am trying to arrive delta % for multiple metrics, all my metric values are in row, so i can’t able to create a calculated field. so i tried to aggregate in sql query (universe /forecast) -1 *100) , but in quicksight visual all this value are getting sum and getting answer as shown in image. could some help me in fixing this issue.

thanking you in advance

2

Hello @Baskar !

I would try updating the SQL function so that you are dividing your delta value by your forecast value then multiplying by 100. You could also keep it as a decimal and format in QuickSight on the field level in the analysis.

This also could be caused by the field well aggregation. If it’s set to sum you could try changing it to max or min.

3

Hi @duncan ,
Thank you for your reply, I also tried the same thing, the values in columns are from different table, so i have arrived summary and appended to my master dataset, the value in remaining column is in $, so i have formatted the value to currency. I can change to numbers but percentage value is getting sum -up which shouldn’t be the case and so i tried adding calculated field to arrive the percentage, as it is required for multiple metric that also didn’t worked. Is there is any alternate way to oversome this

1 Like
4

Hey @Baskar!

Have you tried changing the field well aggregation as well?