I have a set of metrics that, at any point in a given month, I can project what they will be at the end of the month using MTD values and a proportion of “day of month” / “days in month”. I want to start doing these projections on a quarterly basis, but Looker doesn’t have the same functionality for quarters as it does months: for instance I can’t “extract_quarter(now())” in the same way I can “extract_month(now())” to see how far into the period I am at any given time.
Does anyone have any experience / suggestions for quarterly projections in Looker?