With Imply UI's latest "SUBSET FILTER FORMULA" feature, users can filter out the unrelated data by default right at start of opening a data cube.
However, sometimes when a filter is added for a column, the output shows 0 result. For example, user wants to filter only rows with only `Country Iso Code` = `US` in the Wikipedia data source:
But the result shows 0 results
ROOT CAUSE: The problem is admin configured SUBSET FILTER FORMULA using the NAME in the configuration, instead of the actual COLUMN:
After the configuration change, the output shows up correctly.
Comments
1 comment
This doc is outdated. In the SUBSET FILTER FORMULA, use
t."countryIsoCode"='US'
And for more than 1 dimension, using an AND operator,
($countryIsoCode==null).and($channel!='#en.wikipedia')
Please sign in to leave a comment.