Producing percentage outputs on Quicksight

When I try to populate a range of percentage values in my column, it seems to just aggregate all the percentages and provide (before selection) outputs like:
2,291.88 % or 2,700 %

The values in my columns are already in percentage form.

I would like to produce the exact percentage value on my KPI visualisation tile, if one day is selected on my calendar. If I select a few days, can I produce a more resonsable average percentage value for those days instead of values like: 2,291.88 % or 2,700 %

Hi Dinesh,
You could change your value aggregation to avg in your case