Hi all, there is an issue I face. I am trying to calculate percentage of each scope category over total emission. I used the Metrics tool to create total overall emission. But when added into visualisation, it automatically breaks it down by scope category. Is it possible just get the Metrics for overall emission as a whole number when added here? If yes, can I know how?

Hi Minako, I think what you need is BY ALL IN ALL OTHER DIMENSIONS. This clause overrides all attributes - keeping the metric from being broken down at all. As a result, the associated metric will remain aggregated at the highest possible level of aggregation across all dimensions. More details here: https://www.gooddata.com/docs/cloud/create-metrics/maql/filters/overriding-attribute-filters/by-all-in-all-other-dimensions/

it works thanks!