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!

NTile function behavior inconsistency between DV and Oracle database

edited Sep 11, 2019 5:22AM in Oracle Analytics



I am trying to create some data buckets using the NTile function in data visualization, but getting incorrect result when its trying to distribute similar values into different buckets. I have cross-checked it with NTile query function result from oracle database and they don't seem to match. I have attached some screenshots that will give you an idea of the sample dataset and the results I am getting. Is there any reasons for such different results?


Howdy, Stranger!

Log In

To view full details, sign in.


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