Min Max in Adobe Report
Hi,
I just wanted some brief clarity over finding min max and how Dimension data is collected. In my example, I have a tracking call that passes an item name and numeric value that is then stored into the Dimension and Metric respectively. The report Freeform table would look like this:
| Dimension | Metric | Occurences | Metric / Occurences (Avg) |
| Item 1 | 12 | 4 | 3 |
| Item 2 | 3 | 1 | 3 |
| Item 3 | 5 | 2 | 2.5 |
From the report, you can see Metric gives the total sum of each numeric value passed for that item. It is easy to find the average across occurrences of the item. Again, it is easy to find the min max of any of the columns. However, let's say I wanted to find the min max of Item 1's numeric values, or find the min max across all items' numeric values. Is this possible with the current structure?
I assume it is not since Adobe stores each numeric value as a running sum under Metric. Therefore, I would have to create a unique Dimension for each item, and the "items" would be each instance of numeric value.