jaeW_at_Onyx Coach 
-
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: 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: 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: 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: How do I create this simple pivot table?
https://www.youtube.com/watch?v=YgevJkjeFqw&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=26&t=0s here you go!2
