Odd CALENDAR_QUARTER behavior in aggregate model (no annual consideration)

PaulPaul ✭✭
edited June 25, 2020 in Questions
I have an aggregate of opportunities and am trying to group by calendar_quarter.  When I do, it returns only 4 quarters, not 4 quarters per year, but just 4 quarters.  So 1 includes 2018 q1 as well as 2017, 2016, etc... q1 data.  

Any thoughts on why that might be happening?  It's simply the grouping of "Calendar_Quarter(CloseDate)".



  • Pat VachonPat Vachon 💎💎💎
    edited June 25, 2020
    You have to group by both. Calendar_Quarter(CloseDate) and Year(CloseDate).
  • PaulPaul ✭✭
    edited June 25, 2020
    Thanks Pat, but if I wanted to plot the performance of the opportunities quarter over quarter on a line graph, how can I do that if the time attribute is in two fields?  I'd prefer not to create a custom field to do this, but that is my fallback idea (have a formula field on to show the last day of the quarter and then aggregate on that).  Thoughts?
  • Pat VachonPat Vachon 💎💎💎
    edited June 20, 2018
    You can create a formula field on the model.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!