Have you tried using summarization to show total of your "1"s and do not reset that column? that should show the 53 you are looking for.
Good idea, but I actually get 467.
This is because the criteria I'm using in the filter allows for any given
Part Number to have multiple hits.
So when I'm trying to get 53 (the number of unique PNs in the list), those
53 PNs have attributes that match the filter 467. For example a PN can be
delinquent and waiting on a planned order, purchase req, and/or a purchase
order (or multiple orders). Frankly for this metric I don't care why it's
delinquent, just that it is.
I truly need an option that counts the number of lines.
From: Gabriel Barba <email@example.com>
To: Steve Strobl <firstname.lastname@example.org>
Date: 10/22/2012 02:12 PM
A new message was posted in the thread ID:16286 "Working on Metrics and
Scorecards, need help with counting the # of lines in a report":
Author : Gabriel Barba
I figured it out,
Make a metric worksheet with a Part.name column with the grouping function "grouped by" and generate a filter for all the possible failure modes
Then make a composit metric worksheet and call on the column defined above using the "listcount (column name from above)" function and use the grouping function "sum".