4 Replies Latest reply: Oct 22, 2015 6:14 PM by Paul Coiasi RSS

    Counting the records in a period and plotting them on a line graph

      Hi Community!

       

      I have a set of data and each record has a creation date.

       

      I want to plot a line chart which shows the number of records that have been created in either a weekly or a monthly period

       

      I want to show the weeks/ Months across the x axis and the frequency on the y axis.

       

      e.g.    

      IDColorCreation Date
      1001Red10/21/2015
      1002Blue10/20/2015
      1003Blue10/20/2015
      1004Yellow10/19/2015
      1005Red10/16/2015
      1006Blue10/15/2015
      1007Blue10/12/2015
      1008Yellow10/11/2015
      1009Red10/11/2015
      1010Blue10/8/2015
      1011Blue10/8/2015
      1012Blue10/7/2015
      1013Red10/6/2015
      1014Yellow10/5/2015
      1015Red

      10/5/2015

       

       

       

       

      What expression would I use for the Dimension and then would I need to do anything special to the Expressions to enable them to show in the correct period?

       

      Is manipulation of the data in the script required or is there an easy way to do this?

       

      Thanks