Hello, something with the average calculation doesn’t work well, here is an example:
The average should be 89, but it is 87 in the Quicksight calculation,
why? how can i fix it?
Thanks
Hi @InbalK
Can you list down the rows in a table without grouping and then validate?
When you look at visuals that are grouped you may not see the row count that is important in the avg calculation.
Regards,
Giri
Hi @Giridhar.Prabhu ,
It doesn’t matter in my case, i want to do it sum of Safety Score / Number of items (average)
I succeeded make it in the table by this way:
But now I’m not sure how to do it in the kpi because i don’t have the same option:
Thank you
never mind, fixed it, thanks!
1 Like