#DateForumTypeThreadPost
410 Dec 2012 @ 10:36 PSTDatabaseReplyWork around to simulate a variable Partition in RANGE_NBelow is the desired output.  The 'Rank' column is what I need to derive from the other data.  In this case I am ranking the current call based on the number of calls that precede...
304 Dec 2012 @ 09:11 PSTDatabaseTopicWork around to simulate a variable Partition in RANGE_NHi  -- Below is code that will give me a ranked count the number of calls (in our IVR call table) for a particular BTN (business telephone number).  However I seem to be forced to use&nb...
227 Nov 2012 @ 05:51 PSTDatabaseTopicHow to Rank inside a rolling partition window???I'm looking to rank the number of a specific call based on the volume of calls that precede it within a 30 day window prior to the current call.  The challenge ... I am ranking calls over ...
126 Nov 2012 @ 02:34 PSTAnalyticsReplyHow to read only two rows at a time by ordering itI'm trying to rank calls through our IVR based on the number of calls that occurred before it in the previous 30 days (ie is this the 1st, 2nd, 3rd .... call in the last 30 days?)  &...