Skip to main content
Solved

Finding missing hours in a time sequence

  • January 28, 2026
  • 2 replies
  • 20 views
mortenaa
Contributor
Forum|alt.badge.img+3

Hi all

I have been batting my skull against this for some time and havent been able to come up with a solution.

I have about 60 datasets (and will be receiving about 60 every month from now on) where every line has a date and a time and a value containing a number. See attached file. its a dataset from a callcenter where every line is and hour and the number is the number of staff that are answering phones. the number of staff varies from hour to hour and from callcenter to callcenter. but the dataset only contains date hours where a staff memeber has been checked in, if none have checked in here isnt a line. My task is to find the ‘missing’ lines/hours where no staff has been active to monitor if the callcenter has been unstaffed when it shouldnt have been.

 

I cant figure out a way to find these missing lines and add them in an automated way the i can use over and over again. Has anyone tried anything similar and found a solution?

Best answer by ebygomm

You can create a row for each hour by calculating the min and max date times, then calculating the number of hours between them and cloning so that you have one feature per hour. Merge this back to the original data to fill in your empty rows

 

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • January 28, 2026

You can create a row for each hour by calculating the min and max date times, then calculating the number of hours between them and cloning so that you have one feature per hour. Merge this back to the original data to fill in your empty rows

 

    mortenaa
    Contributor
    Forum|alt.badge.img+3
    • mortenaaContributor
    • Author
    • Contributor
    • January 28, 2026

    You can create a row for each hour by calculating the min and max date times, then calculating the number of hours between them and cloning so that you have one feature per hour. Merge this back to the original data to fill in your empty rows

     

    Thank you so much, this works a charm :) 

    Community Stats

    32,398
    Posts
    122,888
    Replies
    40,119
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.