Loading...

qChartview – How to display

qChartview – How to display

Home Forums QuickApps Forum qChartview – How to display

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #5272
      Anonymous
      Anonymous
      Participant

      Disregard.  Used calculated columns to achieve this.

    • #4149
      Anonymous
      Anonymous
      Participant

      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?

    • #5966
      Anonymous
      Anonymous
      Participant

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

    • #5965
      Anonymous
      Anonymous
      Participant

      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

Viewing 3 reply threads

You must be logged in to reply to this topic.