In some instances, you may want to display data that is filtered differently from the rest of your report. For example, you may want to filter your report by location but still display an overall client average.
In this case, you would use the KEEP_ONLY_FILTERS or IGNORE_FILTERS modifier to indicate which filters you would like to apply to the data.
When using KEEP_ONLY_FILTERS, all filters other than the ones you specify will be ignored. Filters are delimited by ‘;’
When using IGNORE_FILTERS, the filters you specify will be ignored. Again, filters are delimited by ‘;’.
#only pay attention to the timestamp filter#location filter will be ignored
{AVG(DATATYPES.SHOW_DATATYPE(KEEP_ONLY_FILTERS=TRENDING_TIMESTAMP).SCORE)}
#only pay attention to the timestamp and group filter
#all other filters will be ignored
{AVG(DATATYPES.SHOW_DATATYPE(KEEP_ONLY_FILTERS=TRENDING_TIMESTAMP;GROUP_ID).SCORE)}
#for RESULT, CROSSTAB, and NESTED report types,
#the KEEP_ONLY_FILTERS modifier should go in the initial report command
{|RESULT|KEEP_ONLY_FILTERS=GROUP_ID}
...
{/|RESULT|}
#ignore the timestamp filter
#all other filters will still apply
#this can be useful for replacing the standard date filters with a custom date range filter
{AVG(DATATYPES.SHOW_DATATYPE(IGNORE_FILTERS=TRENDING_TIMESTAMP).SCORE)}
#ignore the timestamp and group filters
#all other filters will still apply
{AVG(DATATYPES.SHOW_DATATYPE(IGNORE_FILTERS=TRENDING_TIMESTAMP;GROUP_ID).SCORE)}
#for RESULT, CROSSTAB, and NESTED report types,
#the IGNORE_FILTERS modifier should go in the initial report command
{|RESULT|IGNORE_FILTERS=GROUP_ID}
...
{/|RESULT|}
IGNORE_FILTERS can also be used to ignore user permissions for certain data. For more information about how to do this, see Overriding User Permissions.