Hi! I need some help with a couple of questions please 🙏 We have a scenario where we report on Completion rate for an item broken down by user / team. This is the metric we are using: SELECT (SELECT COUNT({label/one_to_ones.id}) WHERE{label/one_to_ones.status}="completed") / (SELECT COUNT({label/one_to_ones.id})) And we usually do a bar chart visualization for this scenario. We want to adjust this percentage to be a weighted one (we also have a metric for the count: SELECT COUNT({label/one_to_ones.id}) Also, when creating a table visualization with the above, and leveraging the "Aggregate -> Avg" feature (as per attached screenshot), how can we make sure this is also the weighted average completion rate? I assume we can achieve this via a specific metric, or using a different visualization - could you share any pointers and suggestions on this, please?

Hi Raffaella, I would recommend you to go through the below thread where the weighted average was discussed in more detail. I believe you should find your answers there: https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1709670040414959 Regarding your second point, unfortunately, the weighted average is not implemented as one of the default aggregations that could be chosen via UI. As you’ve mentioned, this would be always needed to be handled via custom metric.

We will introduce new feature “*Rollup Total*” soon which should let you create total of the weighted averages in your table. The way how it is going to work is that it will compute the metric (like Competition rate in your case) without the breakdown by attributes in the table and display result at the bottom of the table like other totals. The feature is in development currently.

Thanks for the input team, I have tried to play around with the custom metric but still struggling to understand the correct way to put this.

Hi Raffaella, we are just wondering if you made any progress with the metrics you’re looking to create, or if you still need any further assistance with this?

Hi Raffaella, I just wanted to make you aware of this announcement, which introduces the “Rollup total” feature which I believe will make exactly what you want automatically now: https://gooddataconnect.slack.com/archives/C07BH7ZF4UC/p1723124840110439

Hi GD team, thank you for the follow up on this. I guess the issue we are trying to solve for our customers is the following: Example scenario: Team A has 30 items to complete Team B has 10 items to complete Team C has 2 items to complete In a bar chart visualizations, we are using a completion rate metric (SELECT (SELECT COUNT({label/one_to_ones.id}) WHERE{label/one_to_ones.status}="completed") / (SELECT COUNT({label/one_to_ones.id}))) Customer wants to see the top / bottom teams when about completion rate, but given the amount of items differ vastly between teams, just looking at a bar chart with completion rate doesn't give the full picture. I guess maybe instead of focusing on weighted completion rate in metrics we should have a way to visualize both completion rate and count of items? Do you have any suggestions to work through this visualization?

Hi, you may need to specify some threshold for minimum number of items to qualify for a team to be included in the chart. You can be also consider use of Bayes estimator. Some inspiration can be found in https://en.wikipedia.org/wiki/Bayes_estimator, which describes some practical example used by IMDB for top movie ranking. In simpler terms, the fewer ratings/votes cast for a film, the more that film’s Weighted Rating will skew towards the average across all films. I think similar formula can be expressed in MAQL. Scatter plot visualization will let you compare teams and identify best performing teams in top-right quadrant which will show teams with top rankings as well as high number of items. Teams with insufficient number of items or low performing teams will be in other quadrants. A combo chart with dual axis will let you display two metrics too and do comparison.