Replies posted by Ma'ayan
Hi @Jakub and @Joseph Heun,Thank you for the prompt response. I understand the differences between Rollup and Average now, I appreciate you linking the documentation to me. I will share that with the team once I get a little more clarity on the differences in the values between Rollup & Average. A little background, we’re looking at transit agency data to assess total on-time performance (which stops drivers are leaving early, on-time, or late) across certain routes. Essentially, we’re counting <<how many stops were considered early / total number of stops>> to assess the performance over the course of a month to get these values. So, the Avg aggregation is simply averaging the averages of each route (ie. 72.3% + 80% + … + 92.7% / # of observations) , while the Rollup function is averaging all the data points in each category. In this case, Rollup would give us a better indicator of overall service, since it would weight on-time performance more heavily for routes that
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.