I have a table that contains Part Number, Added_date. This table goes back to 2002. Here is what I need to know.
First, I need to know whenever we enter a Part Number into our system(table) that has only been in our shop less than or equal to 5 times.
Second, I want to narrow that result down to just activity in the past 5 days. If 6 days ago, we entered a part for the fourth time since 2002, I don’t want to see it in my results. If we enter a part for the second time since 2002 three days ago, I want to see it.
I did this:
Count Part End As =
Then I put a visual relative filter on the Added_dte “is less than 6”. That seems to work if I am only displaying the Part_Ended_As and “Count Part End As” measure in the table visual but when I added another column, the work order number, the results became incorrect. What am I doing wrong or is there a better way to get this information?