Last tested: Jun 15, 2021
extract_months(${table.date})
extract_days(${table.date})
if(${month} = 2, ${day_of_month} + 31,
if(${month} = 3, ${day_of_month} + 31 + 28,
if(${month} = 5, ${day_of_month} + 31,
if(${month} = 6, ${day_of_month} + 30 + 31,
if(${month} = 8, ${day_of_month} + 31,
if(${month} = 9, ${day_of_month} + 31 + 30,
if(${month} = 11, ${day_of_month} + 31,
if(${month} = 12, ${day_of_month} + 31 + 30, ${day_of_month}))))))))
The above is a potential use case for this! Good luck!
This content is subject to limited support.
thanks @Pieter_DeVries just what I needed! Not surprised you came up with something like this
Nice! I am bummed the pngs didn't survive though.
Yeah I was wondering what the images were showing.
For reference I used the above with this article:
That article was great in showing MTD actuals vs target (and shows if you're ahead or behind the "expected pace" you should be at on the current date) but I used your post to modify it so that it could track QTD.
Thanks!