1 Reply Latest reply on Jul 19, 2016 9:09 AM by Joe Oppelt

    One View on Multiple Boolean values

    Dennis Schuett

      Hi All,

       

      this is my first post and hopefully I could explain what my idea or requirement is.

       

      Currently we are exporting several Tickets from our ITSM Tool within a access database.

       

      For specific kind of Tickets we are flagging values ( boolean within the database ) for impacted regions for example

       

      e.g. Europa, North America, Asia, South America as regions

       

      The flag could be set to true or to false and we have one flag per region

       

      For e.g. an Incident Impacting just Asia:

       

      Asia:True

      North America: False

      Europe:False

      .

      .

      .

       

      2. Example is an Incident which is impacting Asia and Europe

       

      Asia: True

      Europe: True

      North America: False

      .

      .

      .

       

      There are currently several dashboards in place sorting tickets by resonsible units, priority etc.

       

      Now I'Ve want to introduce a filter mechanism for the region.

       

      Because of there are 5 regions implemented I could not implement 5 single filters on a dashboard because I want to show for example all incidents impacting "Asia" if a user is set the filter to "Asia True" all other Region settings needs to be set too.

       

      What I want is a new single Drop Down / List selection possibility  for the Region with predefined values " Asia,North America etc. " . If I set "Asia" for example the existing charts/dashboards should be filtered additionally to all existing filters, for the region which was selected. In this case all tickets with "Region Asia = True" .

       

      Not sure how to realize it because of there are currently 5 database fields within the table .. one per region each of them boolean.

       

      Thanks for your help

       

      Dennis