- This topic is empty.
- AuthorPosts
-
- 10/02/2012 at 2:43 am #5272
AnonymousParticipantDisregard. Used calculated columns to achieve this.
- 10/03/2012 at 1:56 am #4149
AnonymousParticipantHi – I am using a qchartview to display a count of deals as well as a sum of the deal values for a time period. I need the dates to be summarized and displayed as quarters and/or year. For example, dates 1/1/2012 and 2/1/2012 would be grouped and summarized in Q1 2012.
Is this possible?
- 10/03/2012 at 1:56 am #5966
AnonymousParticipantHi Gerald,
The issue I had was grouping the results by quarter/year. What I did was add a cc with the following formula:
=IF(MONTH([Closing Date])<=3,"Q1",IF(MONTH([Closing Date])<=6,"Q2",IF(MONTH([Closing Date])<=9,"Q3",IF(MONTH([Closing Date])<=12,"Q4",""))))&" "&Year
Then for my X Axis I set the field name to be the cc. Hope that helps!
Message was edited by: Stephens-s
I forgot to mention that the Year at the end of the formula is for another cc that I am using for another chart. You could replace that with YEAR([Closing Date]) - 10/03/2012 at 9:04 am #5965
AnonymousParticipantHey st,
I am curious how you did this with cc. Did you somehow total a column? I could use a method for totaling a column in a list and then being able to chart it in the qChartView. Thanks.
Gerald
-
- AuthorPosts
You must be logged in to reply to this topic.