DeepSee: Filtering a filter
When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?
For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?
Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?
Hope that makes sense.
Also, to follow this up, is there a way to order the drop downs? as for dates the oldest dates generally appear to be at the top where as we would prefer it to start with the most recent dates.
Hello Benjamin,
I suggest we discuss these issues in a WRC or TRC. This is the link to Support.
For example, we might want to look into some of these concept: Time vs Data Dimensions, sorting the members in a level from Architect, and the "Depends on" setting for levels that can be set in Architect.
Thanks
Not the best solution, but DeepSee filters by default have a search input, you can enter part of the filter value and only filter values that have it would be shown (after pressing enter).
Hi, Benjamin!
Have you tried dependent levels?
Say you have LevelA which shows dates and LevelB which is applicable for the relevant date values.
Make LevelA depends on LevelB in the Cube.
Then you can place a LevelB filter on the widget in hidden mode with some default value, which is relevant for desired values in LevelA and you'll see in LevelA filter only the desired values on this widget.
Benjamin, just a note: it would be great to have one question per one question posting. Here we have at least three :)