david_cunningham Coach 
-
Re: ETL - How to spread a Budget over two dates within a variable date range.
The easiest way would be to use a date dimension table and a cross join (Cartesian Product). Say you have your budget dataset. You would join your date dimension table (a dataset that has a row for e…1 -
Re: Compare to Budget - Actuals in one Dataset and Budget Values in second Dataset
You'll need to do some mapping to create a way to join. I would also personally recommend aggregating up to a daily budget/actual amount in your ETL. You would then need to join to a date dimension t…2 -
Re: How can I create a Beast Mode field which is a variable figure?
You could use the group by tile in MagicETL to create a new column for the most recent completed month (or last 30 days, or whatever period you want to use). Basically you would use the rank/window f…1 -
Re: If condition between two columns
@DanieleSilva You would use the Formula Tile in MagicETL and then use the code provided above. You can name this column whatever you want.1 -
Re: If condition between two columns
case when Fixed Value is not null then "Fixed Contract" when Spot is not null then "Spot Contract" else "Undefined" END I don't have your actual data, so this is assumin…1
