Page Comparison

...

The following joins are valid:

• [Dim Machines]

• [Dim Dates] (use [Fact Events].[Event Start DateTime])

the following joins are INVALID:

...

1. Event Pareto: All occurrences, durations, and average duration

   1. 

      Filterable by Machine Name and Calendar Event Start DateTime.

   2. Note any correlation to Shift or Job is best achieved by identifying time ranges and filtering to those. Shifts and Jobs not at the hourly level will not be able to perfectly correlate.

...