Michael DeWulf
12/09/2024, 9:49 PMBY ALL OTHER WITHOUT PF
, which is not acting how I expect. I have an "Avg. Customer Value" metric, which alone in an insight is displaying $9,179.61 (see pic below). However, when I combine it with another metric, which filters the same dataset, the value drops to $2,306.22 (see image 2). It appears the second metric is affecting the first, even though I thought I had prevented that with the "by all other" clause. Should I be using some other piece of MAQL to calculate the Avg. Customer Value metric, which is supposed to be independent of the current dimensions and filters?Jakub Sterba
12/09/2024, 11:42 PMMichael DeWulf
12/10/2024, 12:28 AMMichael DeWulf
12/10/2024, 12:57 AMJakub Sterba
12/10/2024, 1:00 AMProductboard
12/10/2024, 1:02 AM