I have a single flat table where a helpdesk ticket can be assigned to a group, closed by a group, and acknowledged by a group. Additionally the table will have time to close and time to acknowledge.
In my presentation, I want to make it easier for the user to select the correct data. Currently I have a selection box for closed group, assigned group, and acknowledge group.
Is there a way I can create one selection box that will show groups but then select either closed group or assigned group or acknowledge group? The presentation charts will have the correct time to close or time to acknowledge displayed. However, as it currently works, a user can select a closed group while looking at time to acknowledge chart and not see the correct information since the closed group doesn't have to be the same as the acknowledge group.
You can create inline tables with your selection group types and link them to your flat tables so that when some one is selecting from inline tables it filters your selection groups too.
