WITH PARENT FILTER EXCEPT

Includes all parent filters, except for any filters specified as a comma-separated list of attributes.

This clause can be shortened to WITH PF EXCEPT.

In EXCEPT clauses, multiple attributes can be specified as a series of comma-separated values.

Example

In the table below, you can see how the WITH PARENT FILTER EXCEPT keyword affects the filtered version of the visualization.

DefinitionVisualization FilterMetric Value
SELECT M1(none)500
SELECT M1F1: Group = X350
SELECT M1F1: Group = X; F2: Priority is Y250
SELECT M1 WITH PARENT FILTER EXCEPT {attribute/priority}F1: Group = X; F2: Priority is Y350

In the above example in the fourth row, the WITH PARENT FILTER EXCEPT includes all parent filters in the metric, except for one: Priority. So, in this case, the Priority filter is not applied to the metric. The generated metric value equates to the value generated in the version in the second row.

Syntax

SELECT ... WITH PARENT FILTER EXCEPT Attribute1,...
SELECT ... WITH PF EXCEPT Attribute1,...