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.
In the table below, you can see how the WITH PARENT FILTER EXCEPT keyword affects the filtered version of the visualization.
|Definition||Visualization Filter||Metric Value|
|F1: Group = X||350|
|F1: Group = X; F2: Priority is Y||250|
|F1: Group = X; F2: Priority is Y||350|
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.
SELECT ... WITH PARENT FILTER EXCEPT Attribute1,...
SELECT ... WITH PF EXCEPT Attribute1,...