Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 3

21-03-2017

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

1 Comment

Avatar

Level 4

16-01-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