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
something like this
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.
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
@danielreyes3rd -
Did @Biswajit_1993 solution answer your question? If so, please mark as Solution. If not, let us know if you still need assistance.