Hi Team, another one from me, sorry 🙂 I noticed this function to aggregate metrics as sum / ratio etc... allows you only to sum 2 metrics, even if I have 5 in this report. I'd like to use this feature to have a final column aggregating all columns to get to 100%. Is there any way to do so? Unfortunately when trying to use the aggregations at column level (clicking the 3 pips in column header, second image), I notice I am prevented from aggregating by columns sometimes. Is there a reason why?

Hi Raffaella, happy to help! 😊 You’re right — the current “aggregate metrics” feature allows combining only two metrics at a time. If you’d like to aggregate all five into one final “100%” column, you’d need to create a custom metric using a formula (for example, summing or dividing your existing metrics). I can also submit this as product feedback for broader multi-metric aggregation support. Regarding column-level aggregations (the three-dot menu), they can sometimes be disabled depending on the chart layout — for example, when attributes are placed in Rows rather than Columns, or when the metric setup doesn’t allow a meaningful aggregation across categories. To aggregate by columns, make sure the attribute(s) you want to group by are placed in the Columns section of Analytical Designer.

@Mauricio Cabezas, thanks for the explanation