You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

TopN functionality in OAC not giving appropriate results

Received Response
edited Apr 24, 2020 4:20PM in Oracle Analytics 13 comments



TopN functionality in OAC is not giving appropriate results. Does any one know how to fix this?

My Top10LoginCount is a custom calculation that is calculated as TOPN(“Login Count”, 10). 

In the screenshot attached, on the right hand side legend only 3 customers are shown.
In case, I change the calculation to TOPN(“Login Count”, 100) and specify 1 to 25 (or so) when asked for range, I can see more customers (upto 10). This means, my requirement is served by using TOPN(“Login Count”, 100).

Here my query is "why does TOPN(“Login Count”, 10) does not work as desired?" 

It should ideally show me 10 customers. Does any one know how to fix this?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!