How to display empty values on a time report? | Community
Skip to main content
Christina_Jarosz
Christina_Jarosz
New Participant
April 3, 2020
Solved

How to display empty values on a time report?

  • April 3, 2020
  • 2 replies
  • 705 views

Our director really likes the visual aspect of seeing how their time has been utilized the past week. However, since not everyone is up to date on their timesheets we are missing people from that view. We'd like to still display that person's name in the chart (even if empty) so we can clearly see who is not completing their timesheet.

Right now the only way to do that is to try and figure out who is missing from the displayed hours.

I was successful in getting a report showing no hours - but it does not break it down by week - this only works YTD.

Has anyone come up with a solution to this? I found some old threads, but, it didn't look like it solved it. I want

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed__AtAppStore

    I have a cheat for this one Christina,

    For each user of interest, go back in time and enter one minute of time on a particular date (e.g. Dec 31, 1999), and then in your report's filter, add an OR that picks up every Hour (and therefore User) that was entered on that particular Entry Date.

    The OR ensures that every end user has a row, every time, whether they've entered time for the current period or not. "Yah busted" -- Jake Peralta.

    Regards,

    Doug

    2 replies

    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStoreAccepted solution
    New Participant
    April 3, 2020

    I have a cheat for this one Christina,

    For each user of interest, go back in time and enter one minute of time on a particular date (e.g. Dec 31, 1999), and then in your report's filter, add an OR that picks up every Hour (and therefore User) that was entered on that particular Entry Date.

    The OR ensures that every end user has a row, every time, whether they've entered time for the current period or not. "Yah busted" -- Jake Peralta.

    Regards,

    Doug

      Christina_Jarosz
      Christina_JaroszAuthor
      New Participant
      April 3, 2020

      Oh my goodness Doug....I could kiss you right now! You are awesome!!!!! If we ever make it to conference, I'm so buying you a drink as a huge THANK YOU!!!!

        Doug_Den_Hoed__AtAppStore
        Doug_Den_Hoed__AtAppStore
        New Participant
        April 3, 2020

        A beer and a kiss? Thanks Christina: it's a date!

        Regards,

        Doug

        Christina_Jarosz
        Christina_JaroszAuthor
        New Participant
        April 3, 2020

        Previous thread: https://one.workfront.com/s/question/0D50z00006Px45SCAR/tasks-assigned-to-a-user-where-users-actual-hours-0

        Terms & ConditionsAccessibility statement

        Loading footer...