Filtered Rows - What about a 'show all' option?
I am currently designing a dashboard which I would like to depict a list of Projects.
The record set is very simple, and like that:
Project Name // Project Manager // Project Status // Project Description
I wanted to represent a view of the Project List, (using the list view components), filtered according to the "Project Status", e.g.:
Show all the Projects which 'Project Status' equals 'Completed'
I used the combo box component, exploiting the 'filtered rows' insertion type, and everything works fine.
(I have also read on this forum the clever workaround to concatenate multiple filters, and tested it successfully.)
But when sifting through the Project list during a presentation, the need may rise to see unfiltered data, thus not applying a certain filter. In my example, that would be showing all the projects, regardless of the 'Project Status'.
As far as I know, the Combo Box component does not allow you to select a 'show all' value, to actually skip the filter.
This would mean that, when I am including a filter in my Xcelsius model (be it a filter component or a filtered rows insertion type) I would always be bound to keep a filter selected during my presentation, losing the possibility of showing all the data. That is a hindrance that would dramatically limits the analysis capabilities of my model,
Now, since I guess that a 'show all' option in a filter drop down list is just too basic for a dashboarding tool for not yet having been asked for, I am perhaps missing something and would like to ask if someone could shed some light on this issue.
Many thanks for your time