4 Replies Latest reply: Apr 10, 2013 12:26 AM by steffenschlindwein RSS

    Count occurrences per number of days between two dates

      Hi,

      I am using =Max([Time Period])-Min([Time Period]) to get the number of days between to date ranges per Visitor.

      Visitor 1 --- 01/02/2013
      Visitor 1 --- 03/03/2013
      Visitor 2 --- 01/03/2013
      Visitor 2 --- 03/03/2013

      Dimension = Visitor, Formula =Max([Time Period])-Min([Time Period])

      my result list looks like this:
      17
      16
      16
      16
      15
      15
      14
      14
      14

      Now I would like to get count per number (occurrences) days and show this as chart.

      17 – 1
      16 – 3
      15 – 2
      14 – 3


      LOAD [Time Period],
      Visitor
      FROM
      [visitor.xlsm]
      (
      ooxml, embedded labels, header is 1 lines, table is [IS1]);

       

      Thank you