1 of 1 people found this helpful
I'm looking for a setting that will result in "Null" and "Non Billable" always being excluded no matter what else happens.
I wish I could just go into the original data set and delete them but I don't have that option.
Hi Paul Heering
By seeing the last two lines, I am suggesting this approach for you. Please use a datasource filter and exclude 'Null' and 'Non-Billable' values from your Datasource.
Please go through this link for more details Filter Data from Your Data Source
I do have this problem and i resolved with this approach.
Please feel free if you have any further queries.
One of the option that did the trick for me, was to change the filter to 'Attribute' from 'Dimension' and select the values for the filter.
By doing this, the filters are retained even after performing dashboard actions.
Hope this helps
see the approach attached
I've used the statement below to eliminate the Furniture category
then when you create the viz - put in the Dimension from the D/b In my case Category
and set to "All Values in Context"
if you want to drive it from a menu on the db - load the sheet and apply the filter to all sheets
or you can drive it from action filters
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
actions and filters.twbx 2.4 MB