Count unique records from related application
Need help in counting the unique records from the cross referenced application. Here is the scenario.
Application A is cross referenced with Application B. Application B is cross referenced with Application C.
I have created a calculated field in A which gives me the count of related records in Application C with the help of calculated field in Application B. However, the result comes out as 6, instead of 4 considering only the unique records.
Is there a workaround to get the count of unique records in application C.
- Community Thread
- count of records
- count of unique records
- count of unique records from related application
- count of unique records in cross referenced application
- Forum Thread
- RSA Archer
- RSA Archer Suite
This need of counting unique records is widespread, with multitude of business situations where we would need it, such as:
- Number of unique controls per company, division, etc.
- Number of unique risks per risk hierarchy category, company, division, BU, etc.
While it is technicaly possible to use datafeeds to satisfy this need, such solutions do not scale properly. They may be ok for a single instance but would skyrocket your total cost of ownership if used widely.
I strongly urge you to request from support the development of COUNTUNIQUE and SUMUNIQUE functions as a feature enhancement.