WITHOUT PARENT FILTER
Removes parent filters from being applied to the metric. All parent filters specified in visualization, 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 visualization.
|Definition||Visualization Filter||Metric Value|
|F1: Group = X||350|
|F1: Group = X||500|
Since the metric in the third row removes the parent filter in the visualization, the returned value matches the calculation when no visualization filter is applied in the first row.
SELECT ... WITHOUT PARENT FILTER
SELECT ... WITHOUT PF