Forum Discussion
Creating a condition based event counter
I have a dataset with time and inventory levels. I want to create a counter (within a designated time period) of the # of unique rows where the inventory drops below a specified limit (in this examp...
If I am reading that correctly, it will flag a "1" for each occurance below 1000. For the first part of my question, I'm only looking for the flag to be there for the 1st record below 1000 (and then reset once the inventory rises above 1000 again).
HashamNiaz
Solution Sage
Solution SageHi idymkowski !
Got it, please paste sample data for your problem. I have overlooked your initial requirement.
Regards,
Hasham
a sample spreadsheet was in the original post. Do you need more than that?