Hello to everyone,
I am facing an issue while try to calculate the average ratings of an app using the following fields (returned by the API calls):
In order to calculate the average ratings of an app for period X, i would use the following formula (for all the record in that period):
sum(one_star_incremental+ 2* two_star_incremental+ 3* three_star_incremental+4*four_star_incremental + 5*five_star_incremental) / sum(total_count_incremental)
This formula returns wrong data compared to the dashboard I created on data.ai portal.
Can someone help me?
Best answer by Alex WilliamsView original