Get average

Hello can you help me how to get average on this.

Hi @danielreyes3rd - Are you looking forward a solution in stead of Total, you need average? If yes, I believe it is not possible in QuickSight now. You can have a KPI which can have only average.

Tagging QuickSight experts @Karthik_Tharmarajan @Max @David_Wong for their feedback.

Regards - Sanjeeb

1 Like

something like this
image

hi @danielreyes3rd ,

You can use the avg function to calculate the average of your data.

Just need to create one calculated field and use avg(Times Answered) and put it into the values field well.

Use your field Times Answered in place of Cost.

image

Thanks & Regards
Biswajit Dash

thats my problem I cant make that times answered as calculated field(Cost).
cost = count({times_answered})
then
Percentage= avg({cost}) this will cause errors

Hi @danielreyes3rd ,
Use avgOver() instead of avg()

Just like below.

image

Thanks & Regards
Biswajit Dash

1 Like

@danielreyes3rd -
Did @Biswajit_1993 solution answer your question? If so, please mark as Solution. If not, let us know if you still need assistance.