-
Finding the latest date with specific criteria
I work in the training area at my organization. We are trying to determine "What is the latest date they have completed all of their required training?" For example, a new agent comes in, and they are assigned Program A, Program B, and Program C. We want to know what the latest completion date is when they have completed…
-
Beast Mode Period-over-Period issues
Okay, so I'm trying to do 4 Beast Modes, and I cannot seem to get the right data. I'm trying to find the average amount of dollars per time period. Here's what I have come up with so far, to no avail: * Current year-to-date* avg(CASE WHEN `Date` >= DATE_FORMAT(CURDATE(), '%Y-01-01') THEN `Dollars column` END) or * AVG(CASE…
-
Split dates in single column into multiple columns
I want to take a column that contains dates and split it into at least 2 columns to find the date difference between the two. So, for example, I have a client ID and a transaction ID that are unique. The transaction ID does not repeat, but the client ID does based on their purchases. My date column is their purchase date.…
-
Combine Data Issues
I have 3 datasets called FYC Historical, FYC Details-Current, and FYC Summary. I have combined these with our VUE Production Clean Dataset and called the dataflow VUE FYC Combine (takes almost an hour to run). I have then taken this output dataset, called VUE Historical and Current Test, and placed it into a copy of an…