Hey all, I'm wanting to update a time filter to use in module views but am having a hard time figuring out how to create a specific condition. I want to have a filter for the current quarter and the previous five quarters as well (so 6 quarters total).
Right now I have a line item that gives each quarter a decimal value descending from the current quarter with this formula: IF Current Quarter?? THEN 1 ELSE NEXT('Trailing 6 Q Count') / 2 -- Then a line item boolean that has this formula: IF 'Trailing 6 Q Count' > 0.03 THEN TRUE ELSE FALSE
This allows me to filter the most recent 6 quarters (or any amount really), but I feel like there is a better way to write the formula. I've looked at other time functions like LAG, PREVIOUS, etc. but don't know how to make them return a range of periods rather than a single result.
Any help appreciated!