4 Replies Latest reply on Oct 30, 2013 1:05 AM by JanWinberg

    How to create report with dates that do not exist in data set?

    JanWinberg

      Title

      How to create report with dates that do not exist in data set?

      Post

           Hello,

            

           Haven't been using FM for awhile and wondered how I could create report described below. I have following data:

           Date                        Time 
           1.10.2013 08:30     200
           1.10.2013 11:20     300 
           2.10.2013 13:00     400
           2.10.2013 14:00     110
           4.10.2013 15:00     500
           5.10.2013 09:30     10
           5.10.2013 10:00     100
           5.10.2013 15:00     80
           5.10.2013 18:30     300

            

           And report I would like to generate based on above data:


           Date                Total       Time >100
           1.10.2013        2              2 
           2.10.2013        2              2
           3.10.2013        0              0
           4.10.2013        1              0
           5.10.2013        4              2

           So, all dates should be reported whether there is data record for that date or not. If no records for specific date then report shows in total 0. Additionally report should also calculate how many records for specific date has Time value over 100.

           Jan