

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe this:
(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, productID = {"=Count(LicenceeLicenceID)>10"} >}LicenceeLicenceID))
/
(Count({<tType={'AllLicences'}, productID = {"=Count(LicenceeLicenceID)>10"}>}LicenceeLicenceID))
I hope it helps.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
AllLicences is just a subsection because the tables are duplicated for a reason and so i'm only looking here

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try this:
(Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}, Over24Hour={'Under24Hours'}>}LicenceeLicenceID))
/
(Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}>}LicenceeLicenceID))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe this:
(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, productID = {"=Count(LicenceeLicenceID)>10"} >}LicenceeLicenceID))
/
(Count({<tType={'AllLicences'}, productID = {"=Count(LicenceeLicenceID)>10"}>}LicenceeLicenceID))
I hope it helps.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
