View the original community article here
Last tested: Jun 15, 2021
This requires 3 easy steps of Table Calc magic.
Here is a picture to get an idea.
The steps are below
- Create an extract months table calc
extract_months(${table.date})
- Create an extract days table calc
extract_days(${table.date})
- Create Days of Quarter, referencing the month and adding days to the days based on quarter.
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.