I am creating an app that let’s users upload video and then all the other users can rate that video. I am trying to surface the Overall Average Rating for All Users (one number, i.e. a team average) and am having trouble.
This is how I set it up so far:
Each time a video is rated, I set up workflow that will updated the video creator’s average video rating.
So now each video creator has an average rating that is personal to them and saved against their User.
Now, I want to create a dashboard page that surfaces one number which represents All User’s Average Video Rating (This number would not be stored against a particular User or a Particular video).
Where would I trigger this calculation from in terms of workflow? I originally thought upon page load of the dashboard - but that doesn’t seem to be available.
And where would this number be stored against? I’m struggling - thanks for the help!