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

TopN functionality in OAC not giving appropriate results

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

Content

Hi,

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.

Register

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