| # | Date | Forum | Type | Thread | Post |
|---|---|---|---|---|---|
| 4 | 10 Dec 2012 @ 10:36 PST | Database | Reply | Work around to simulate a variable Partition in RANGE_N | Below 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... |
| 3 | 04 Dec 2012 @ 09:11 PST | Database | Topic | Work around to simulate a variable Partition in RANGE_N | Hi -- 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... |
| 2 | 27 Nov 2012 @ 05:51 PST | Database | Topic | How 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 ... |
| 1 | 26 Nov 2012 @ 02:34 PST | Analytics | Reply | How to read only two rows at a time by ordering it | I'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?) &... |