4 Replies Latest reply: Oct 19, 2018 11:53 AM by Sunny Talwar RSS

    Limiting Set Analysis by >10

    Alex Tomlins

      I'm having a bit of a moment. I remember doing this before somewhere in one of my applications. I would like to only include products where the count of LicenceeLicenceID is above 10 say. The percentages are too sensitive so i'dd like to excllude those products. Completely forgotten.



      (Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}>}LicenceeLicenceID))


      /


      (Count({<tType={'AllLicences'}>}LicenceeLicenceID))


      Thanks,


      Alex

        • Re: Limiting Set Analysis by >10
          Alex Tomlins

          AllLicences is just a subsection because the tables are duplicated for a reason and so i'm only looking here

          • Re: Limiting Set Analysis by >10
            youssef belloum

            Hi,

             

            you can try this:

             

            (Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}, Over24Hour={'Under24Hours'}>}LicenceeLicenceID))


            /


            (Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}>}LicenceeLicenceID))

            • Re: Limiting Set Analysis by >10
              Andrea Gigliotti

              maybe this:

               

              (Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, productID = {"=Count(LicenceeLicenceID)>10"} >}LicenceeLicenceID))

              /

              (Count({<tType={'AllLicences'}, productID = {"=Count(LicenceeLicenceID)>10"}>}LicenceeLicenceID))


              I hope it helps.

              • Re: Limiting Set Analysis by >10
                Sunny Talwar

                Not entirely sure if you want to exclude less than 10 for all tTypes or just where it is AllLicences? May be try one of these

                 

                (Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, LicenceeLicenceID = {"=Count({<tType={'AllLicences'}>}LicenceeLicenceID) > 10"}>}LicenceeLicenceID))


                /


                (Count({<tType={'AllLicences'}, LicenceeLicenceID = {"=Count({<tType={'AllLicences'}>}LicenceeLicenceID) > 10"}>}LicenceeLicenceID))

                 

                or this

                 

                (Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, LicenceeLicenceID = {"=Count(LicenceeLicenceID) > 10"}>}LicenceeLicenceID))


                /


                (Count({<tType={'AllLicences'}, LicenceeLicenceID = {"=Count(LicenceeLicenceID) > 10"}>}LicenceeLicenceID))