2 Replies Latest reply on Oct 24, 2018 6:04 PM by Shaun Ng

    Creating compliance dashboards with multiple parameters

    Shaun Ng

      Hi,

       

      I am trying to build a dashboard that would display program compliance using multiple parameters as requirements.

       

      I've attached the requirements and a sample data set.

       

      Appreciate if you can recommend the best logic to compile this set of requirements and show them up as Compliant or In Progress (non-compliant) counts.

       

      Thanks

        • 1. Re: Creating compliance dashboards with multiple parameters
          venkatram

          Hey Shaun,

           

          Didn't understand much about you requirements, there is no compliance metric in your sample file, it have

           

          Number of sales Cert, Can you please explain us more clearly bit more.

           

              

          Partner CompanyPartner TypeCountryNumber of Sales Cert (ABC-1000)Number of Sales Cert (ABC-2000)
          Partner ADistributorUnited States32
          Partner BDistributorLatin America21
          Partner CPlatinumGermany108
          Partner DGoldSingapore51
          Partner ESilverSlovakia20
          Partner FGoldCanada24
          • 2. Re: Creating compliance dashboards with multiple parameters
            Shaun Ng

            Hi,

             

            Have a look at the first tab which includes the requirements.

             

             

             

            Distributor

             

            Platinum

             

            Gold

             

            Silver

             

             

             

            Sales

             

            Pre-Sales

             

            Sales

             

            Pre-Sales

             

            Sales

             

            Pre-Sales

             

            Sales

             

            Pre-Sales

             

             

            United States

             

            3

             

            2

             

            6

             

            4

             

            4

             

            2

             

            1

             

            -

             

             

            Canada

             

            3

             

            2

             

            6

             

            3

             

            4

             

            2

             

            1

             

            -

             

             

            Latin America

             

            2

             

            2

             

            2

             

            2

             

            2

             

            2

             

            1

             

            -

             

             

            UK, Russia, Germany

             

            5

             

            3

             

            5

             

            3

             

            4

             

            2

             

            2

             

            -

             

             

            Netherlands, Spain, Italy, France, Sweden, Switzerland

             

            3

             

            2

             

            4

             

            3

             

            3

             

            2

             

            2

             

            -

             

             

            All other EMEA Countries

             

            2

             

            2

             

            2

             

            2

             

            2

             

            2

             

            2

             

            -

             

             

            APAC

             

            3

             

            3

             

            2

             

            2

             

            2

             

            2

             

            1

             

            -

             

             

             

             

            Sales Certification

             

            ABC-1000

             

             

            Presales Certification

             

            ABC-2000

             

             

             

             

             

             

            Eg. Distributor in United States need to have 3 sales certs (ABC-1000) and 2 Presales cert (ABC-2000) to be "Compliant"

             

            If non-compliance, show the current count as "In Progress"

             

             

             

             

             

            Regards,

             

            SHAUN NG