Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2005 @ 16:52:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Julie:

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,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>