1 Reply Latest reply on Apr 29, 2015 4:16 PM by philmodjunk

    Charting month to month totals without daily totals

    gotmoldstarthere

      Title

      Charting month to month totals without daily totals

      Post

      How can i chart monthly totals year to date without including daily totals? When i go to chart the data it breaks it down by day and the chart is just a blob. 

        • 1. Re: Charting month to month totals without daily totals
          philmodjunk

          Use a summary field that computes the sub totals that you want to chart. Sort to group the records by month. In your data source options, be sure to specify the option for "found set", "summarized data". (I'm not recalling the exact wording.)

          To group your records by month, one way is to add a calculation field with date as the return type with this calculation:

          YourOriginalDateField - Day ( YourOriginalDateField ) + 1

          This computes a date for the first day of the month for all dates in the same month. You can then specify this field in your sort to get one date point for each month.