2 Replies Latest reply on Aug 31, 2012 6:08 AM by daniel.rodrguez

    How to graph a data set disregarding the year of the records but only the month

    daniel.rodrguez

      I have a data set with records with a date on several month and years. So if I would like to graph the records on the time, I can drag number of records (measure) in the rows and the date (dimension) in the columns and I obtain easily that graph. But I would like to graph only the number of records (sum) by month, independently of the year they have.

       

      For example, I could do that in Excel summarizing the records by months and then graphing that values vs months (as the picture inserted).

       

      Values by Month.png