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.

Example

In the table below, you can see how the WITHOUT PARENT FILTER clause affects the filtered version of the visualization.

DefinitionVisualization FilterMetric Value
SELECT M1(none)500
SELECT M1F1: Group = X350
SELECT M1 WITHOUT PARENT FILTERF1: Group = X500

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.

Syntax

SELECT ... WITHOUT PARENT FILTER
SELECT ... WITHOUT PF