WITHOUT PARENT FILTER
Removes parent filters from being applied to the metric. All parent filters specified in insight, dashboards, and any metrics in which this metric is nested are ignored.
This clause can be shortened to WITHOUT PF.
In the table below, you can see how the WITHOUT PARENT FILTER clause affects the filtered version of the insight.
|Definition||Insight Filter||Metric Value|
|F1: Group = X||350|
|F1: Group = X||500|
Since the metric in the third row removes the parent filter in the insight, the returned value matches the calculation when no insight filter is applied in the first row.
SELECT ... WITHOUT PARENT FILTER
SELECT ... WITHOUT PF