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
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?