Question on Pigment's New Advanced Aggregator

Adding some screenshots to make things clear, for exp, in my table I only have 1 Revenue per Volume metric, and as you can see Metric A and Metric B options are all blank

 

Hi There!

Thank you for the positive feedback about the addition of the advanced aggregator, we’re happy to hear it!

Advanced Aggregator only lets you pick Metric A / Metric B from metrics that are available in the current table/view, and some metrics can also be hidden as operands if they already have an Advanced Aggregator or an incompatible “Show Value As” setup.

To make it work for “Revenue per Volume”, add the base metrics (Total Revenue and Total Volume) to the same view, then set:

• Metric A = Total Revenue
• Metric B = Total Volume
• Calculation = Ratio (A/B)

That way Pigment computes totals as Sum(Revenue) / Sum(Volume), rather than summing the already-calculated ratio.

We also have a useful Knowledge Base article in the link below which you may find useful.

• https://kb.pigment.com/docs/totals-aggregator-panel#advanced-aggregators

Hi ​@Gigi ,

This approach works well for ratios where the underlying metrics have aligned dimensions (assuming so). However, when working with metrics from mismatched dimensions—where a new calculated field is required to align them—the current 'advanced aggregator' is insufficient. In these scenarios, simply adding and hiding the original metrics does not resolve the summary-level discrepancies as no such manipulation of dimensions can be done except basic math operations.

Ideally, we need an advanced aggregator function that supports formula-based summaries, allowing the summary level to replicate the specific calculation logic defined within the metric itself.