Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 07 Mar 2013 @ 21:28:17 GMT


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


Subj:   Re: 'Median' value of three dates
 
From:   Prescott, Kyle R

For a 3 month sliding window, you can do the following on the windowing function providing you have set number of rows in the window (i.e. monthly statement amounts that you can count on being static). If you know you will always have 3 values in the list to select the median just qualify the result to be the second value in the partition.

ROWS BETWEEN 2 PROCEEDING and CURRENT ROW


Otherwise you can use the calendar table and derive the quarter_of_calendar value and add that to the partitioning (i.e. account_number, quarter_of_calendar). The median average (middle value) will still be applicable no matter the row volume - as long as you can quantify it.


Kyle Prescott | DBA Manager | Unum-GHDS | Chattanooga, TN



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019