hi
I need a Average formula to create an item (Calculated Type ) . I want to split an interface's data from the first day of the month to the last day of the month into 5-minute pieces and get the average of them and give them the Maximum among these averages.
See the figure below for a better understanding
I need a Average formula to create an item (Calculated Type ) . I want to split an interface's data from the first day of the month to the last day of the month into 5-minute pieces and get the average of them and give them the Maximum among these averages.
See the figure below for a better understanding