Hi,
Looking for help to calculate the number of instances wherein a assigned limit has been utilitzed greater than or equal to 90%.
ColA having Date ColB having Individual names ColC having limit utilization in %age and ColD having Instances (the desired output).
Case: If individual (Tom) utilized limit >= 90% even for single day (06th Dec) Instance 1 will be counted. Now utilization is >= 90% from 2nd Dec to 4th Dec than its another instance. Total 2 instances for Tom where limit utilization is >= 90%. For another individual (Jerry), its from 03rd Dec to 10th Dec where limit utilization is >= 90%, here only 1 instance will be counted.
Need to capture count of continuous limit utilization at every instances. (limit being >= 90%)
sample date range is provided, date wise data is arranged for hundreds of individuals for several months in this manner
Any help/suggestion will be much appreciated.
Looking for help to calculate the number of instances wherein a assigned limit has been utilitzed greater than or equal to 90%.
ColA having Date ColB having Individual names ColC having limit utilization in %age and ColD having Instances (the desired output).
Case: If individual (Tom) utilized limit >= 90% even for single day (06th Dec) Instance 1 will be counted. Now utilization is >= 90% from 2nd Dec to 4th Dec than its another instance. Total 2 instances for Tom where limit utilization is >= 90%. For another individual (Jerry), its from 03rd Dec to 10th Dec where limit utilization is >= 90%, here only 1 instance will be counted.
Need to capture count of continuous limit utilization at every instances. (limit being >= 90%)
sample date range is provided, date wise data is arranged for hundreds of individuals for several months in this manner
Any help/suggestion will be much appreciated.
