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

# Limiting Set Analysis by >10

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

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

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

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

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))