Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

NTile function behavior inconsistency between DV and Oracle database

Question
32
Views
0
Comments
bi_bits_92
bi_bits_92 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Content

Hi,

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?

Untitled.png

Tagged: