Limiting Set Analysis by >10

[alextomlins]

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

[alextomlins]

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

[YoussefBelloum]

Hi,

you can try this:

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

/

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

[agigliotti · Accepted solution]

maybe this:

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

/

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

I hope it helps.

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