I have a list of items that have multiple date-oriented entries. I have a numerical field that indicates days since last scan, so I can filter based on the lowest number of days per item. What I am trying to do is count the number of items, based on the lowest number of days since scan and categorize them by that number of days (0-30, 30-60, 60-90 for example). I have not been able to accomplish this in an indicator widget. I can get my totals in a pivot using If statement and a counter, but I can't get just the count with a single formula.
Please sign in to leave a comment.