To GoodData homepage

Replies posted by Ma'ayan

1 Reply

M
Ma'ayanNew Participant
asked in Metrics and MAQL

Rollup Methodology

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

4
Joseph Heun
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings