Hello,
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)”.
Thanks!
Paul
Question
Odd CALENDAR_QUARTER behavior in aggregate model (no annual consideration)
+7
+7Thanks 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.