Adhoc Missing Time Report - not all records displayed

Products

• Clarity PPM On Premise

Issue/Introduction

1. I'm trying to use ad hoc to create the Missing Time Report.
2. I cannot get it to return all the records displayed in the Out of the box report

Cause

1. The Missing Time Report looks at all Open Time Periods and even if a timesheet has not been created the report shows that period as missing.
2. In the Time Management Domain in the Missing Time section you need to already have a timesheet created, otherwise it will not show from that section

Resolution

Use PowerBI and the query from the Missing Time report to create the adhoc report.