3 Replies Latest reply: Nov 11, 2014 11:53 AM by Mateusz Majoch RSS

    How to use weekly data in daily analysis

      I have huge payroll data with weekly date (meaning
      consecutive Thursdays). I need to use that for daily analysis.


      So for example when I am creating a chart (where dimension
      is Date and expression is “count( disctinct PersonelNumber)” ) I want to have a
      workforce shown for each day, not only for Thursdays. In payroll I have field “Date
      from” and “Date to” but I do not know how to use it.


      What would be the best approach to such issue? Any help would be appreciated.