AnsweredAssumed Answered

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

Question asked by JanWinberg on Oct 28, 2013
Latest reply on Oct 30, 2013 by 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

Outcomes