Could someone help me create a query that will return quarterly results? I have one for EOM and Previous Week, now I'm looking for a quarterly view.. Is that possible?
What exactly are you looking for?
There are already quarter_of_year and quarter_of_calendar columns in sys_calendar.
And a calculation of start and edn of quarter as date would be somehing like