1 2 Previous Next 15 Replies Latest reply on Aug 21, 2018 9:32 AM by Stephen Groff

    In need of an LOD, but unsure how to create

    Stephen Groff

      Hi all,

       

      I have a [Date]

       

      I have a list of machines [SERIAL No] for the entire year. And a count of the total machines produced [Machine Count]

       

      I have a list of Defects [Event No] - All of which have a [Serial No] tied to it

       

      I have a list of [Work Center]  - All of which are tied to the defect, which in turn has a serial # tied to it.

       

      So in the same row (in a table) I have the [Date], [Event No], [Serial No] and [Work Center]

       

      Question:  Of the total number of machines I produced today, which of them were free of Assembly Defects ([Work Center]="Assembly").

       

      I need this to come out as a solid number.... drag and drop... and poof!  There's my number of Machines Free of Assembly Defects for that day.

       

      I've attempted this on a number of occasions, but I'm just not knowledgeable enough with LODs.  Please help!

        1 2 Previous Next