Forum Discussion
Measure help
I have group values 0-80, 80-85, 85-90, 90-95 and 95-100. I want to calculate one average value per ID and then count how many values are in those groups. Lets say 15 IDs all have an average be...
Fowmy Here's an example in Excel. So i have the ID, average of the values for each ID and then a count of the averages shown on the diagram. I can't really share the data with you but i hope this helps to clear the picture.
Anonymous
I have attached a file that was used to solve a similar problem, please check and adjust as per your need.
You can download the file: HERE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š