Archives of the TeradataForum
Message Posted: Tue, 22 Mar 2005 @ 16:52:06 GMT
Based on your query, the segment_value is the only value involved in the evaluation of the decile. So, the answer to your question is yes. Equal values will all go into the same decile and therfore, with several seqments having the same value appear in the same decile.
If you do not want this to be the situation, you need to provide tiebreakers in the format of additional sort columns. Lets say for example that each of the segments have a different date and they makes a distinction between them, segment_date becomes a secondary sort of either ASC (default) or DESC as in:
> Select > Segment > ,quantile(10, segment_value, segment_date DESC) as Decile > from > TableX
This should cause a more even distribution of the data between the 10 categories. If this doesn't obtain enough of a division, add more sort columns using DESC where appropriate.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|