Forum Discussion

Matski469's avatar
Matski469
Frequent Visitor
3 years ago
Solved

Need to graph weekly yield by value

I have manufacturing data coming in that says whether a part is good, bad, or some category in between.  The data is item by item, so I'm trying to count the values.  What I can't seem to do is calcu...
Need Help
  • ToddChitt's avatar
    ToddChitt
    3 years ago

    Try these measures:

    My Count of Good = CALCULATE ( COUNTROWS(MyTable), [Condition] = "Good" )

    Total Rows = COUNTROWS(MyTable)

    Percent Good = DIVIDE( [My Count of Good], [Total Rows], 0 )

     

    All those measures will respect the weekly slice when you plot.

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
3 years ago

Try these measures:

My Count of Good = CALCULATE ( COUNTROWS(MyTable), [Condition] = "Good" )

Total Rows = COUNTROWS(MyTable)

Percent Good = DIVIDE( [My Count of Good], [Total Rows], 0 )

 

All those measures will respect the weekly slice when you plot.