Show data from current month plus 11
I have been reading the posts about filtering data by the current day/date. They haven't helped my question. I want to show forecast data for 12 months starting with the current month. All dates in the data set are first of the month. Can I filter in the dataset with ETL? Would it be better to filter in the card? If so,…
Running total: ETL or MySql?
I want to create a running total that resets every year. I've seen posts for doing it with ETL and a window function and others for MySQL and I am lost on which way would be best. The data table is similar to this : Month Revenue Reimbursables 1/1/2018 100 5 2/1/2018 97 11 3/1/2018 102 8 etc. In ETL, I calculate the Net…
Convert YYYYMM field to date format
I have a numeric field that is setup YYYYMM that I would like to convert to a date (201812 = 2018-12-01) . This data comes through workbench 5. I can't find a way to change the field to a date in ETL so I wanted to push it in from workbench. I tried a concatenate(Left(Period,4),'-',Right(Period,2),'-',01) so it would look…
Deltek Vision connector
Is anyone using the Deltek Vision connector? Are you getting the data you expect and what do you see is missing? thanks