Get average

Question & Answer
1

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

image
image749×218 20.4 KB

2

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
3

something like this
image

4

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

5

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

6

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

Just like below.

image

Thanks & Regards
Biswajit Dash

1 Like
7

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