Finding largest average out of multiple datatypes

[jcjags63]

I’m trying to find the largest average out of 5 different datatypes.

What I am trying to do is display the highest value and lowest value

I’ve tried grouping but I feel like I’m missing something with the logic. The parent datatype which houses these is called “Reviews”

Any help would be appreciated.
Thanks

[firstfifteensoftware]

From my “I’m not proud of how I did it, but it works.” box of code:

You could write the max and min for each category out to a table:

Category
Value

Then do a search for all entries:value’s min and max. That would give you the max and min as well as the category.