[Anonymous]

Disregard.  Used calculated columns to achieve this.

[Anonymous]

Hi – 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?

[Anonymous]

Hi 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])

[Anonymous]

Hey 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

[Author]

Posts