A matrix report of a timesheet does not show days without results unless it's sandwiched between two results that have results. | Community
Skip to main content
Level 2
March 21, 2017
Archived

A matrix report of a timesheet does not show days without results unless it's sandwiched between two results that have results.

  • March 21, 2017
  • 2 replies
  • 449 views

Link to Video: https://ilos.video/OADIBV

General STEPS:
1. Log in to your account
2. On any task log some hours for yesterday and tomorrow, leave today blank
3. Create an hour report -> set a filter on that task ID and Hour > Entry date between Yesterday and Tomorrow
4. In the Grouping switch to Matrix grouping -> set the grouping
Row Groupings:
Owner Name
Column Groupings:
Hour -> Entry Date (Grouped by Days).
Make sure the "Show days with no results" is checked
5. Run the report and note that today is showing in the results with no data as expected
6. Edit the report and change the filter to be Between today and tomorrow or yesterday and today
7. Run the report and see that only the data for Tomorrow will show. The column for today won't show up

2 replies

Level 2
January 17, 2019

We have had this problem as well, so users think the report is broken when it just isn't displaying the zero data days

July 9, 2024

Anyone managed to find a solution on this?