Sharing my thoughts on the issues in the advanced aggregators I have experienced -
- The Advanced aggregator works well for basic math operations between metrics where the underlying metrics have aligned dimensions. 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.
- For the Advanced Aggregator to function properly, at least one of the two metrics must remain visible in the table. It will not work if both metrics are hidden—a table visibility restriction that requires showing an extra metric which might not be even required to show.
- In certain cases, line items completely vanish from the table after applying the Advanced Aggregator—even when all conditions are met. Root cause unidentified.
Happy to hear your thoughts/ suggestions to work better with it.