Overview
The customer is requesting a new Parts widget metric that simply counts the number of unique part records returned based on selected filters. Instead of quantity-based calculations (e.g., “Parts in Stock”), the widget should support a true Parts Count metric and allow advanced quantity comparison filters such as “Less Than” or “Greater Than.”
Current Limitations
• There is no widget metric that counts distinct part records based on applied filters.
• Existing widget calculations focus on quantity totals (e.g., total parts in stock), not record count.
• “Understocked” is only available as a predefined condition and does not allow flexible quantity comparison logic (e.g., less than 2, greater than X).