Hello -
I would like to create a quick averaging tool based on multiple criteria's.
Criteria #1: Route Number
Criteria #2: County Name
Criteria #3: Begin Mile Range
Criteria # 4: End Mile Range
My challenge is that if the ' begin and End mile range' go over multiple segments, how do I average all data points between?
For example (image below) - my begin mile is at '1.229' and the end mile is '5.238'. I would like to average everything between them.
I would like to create a quick averaging tool based on multiple criteria's.
Criteria #1: Route Number
Criteria #2: County Name
Criteria #3: Begin Mile Range
Criteria # 4: End Mile Range
My challenge is that if the ' begin and End mile range' go over multiple segments, how do I average all data points between?
For example (image below) - my begin mile is at '1.229' and the end mile is '5.238'. I would like to average everything between them.