I have a handful of metrics that I created that only work correctly in reports where variables/attributes are used, but if I include them in a headline report with no/minimal filtering, they are not calculating correctly. Here is an example of the MAQL code, and then 2 reports using this metric on the same dashboard with the same filters applied. One you can see is broken down using the variables and attributes and the other is not. The totals do not match up.
The variables are both numerical values as well as filtered variables.
Is there something I should be including in the MAQL that will allow the results to calculate according to the variables and attributes listed below without explicitly including those in a report?
Best answer by Moises MoralesView original