jaeW_at_Onyx Coach 
-
Re: Need to control a recursive with a Timestamp
your scenario is unclear. please define what one row means in your input dataset. if i had to guess the granularity is one row per phone call. and it sounds like the phoneCall date can be updated aft…2 -
Re: Date Range Buckets
your syntax for a case statement is wrong. case when `est_ship_date` < DATE_ADD(CURRENT_DATE()interval 3 days) then ‘next 3 days’ when `est_ship_date` < DATE_ADD(CURRENT_DATE()interval 7 days) …2 -
Re: SQL Queries for SQL Server Datasource
This is a doozy of a question, and i strongly recommend you find someone who really knows their stuff to help you plan out your implementation ...because you don't want to spin your wheels. (that sai…2 -
Re: Create Data that does not exist
@kacy in order to analyze usage, particularly in the context of 'no usage', you have to have two pieces of data 1) a list of all the product contracts (it sounds like you have a start date and end da…2 -
Re: Need Advice on Approach: Producing "... to date" comparisons when data granularity is mixed
piece of cake. You need two chunks of data. "Sales Actual by day" and "Financial allocated by day." Yes, you need to break your financial data into one row per day. Decide if you …2
