topic Find the maximum value, corresponding dimension in GeoAnalytics

Find the maximum value, corresponding dimension

qingkong — Wed, 29 Jan 2025 15:21:42 GMT

I want to find the maximum qty value of the Country, and the maximum value should return the details of the Country

Let's say the maximum value of Country is 20000, and the corresponding Country is US

joostvanegmond7 — Wed, 31 Jul 2024 07:32:55 GMT

Although this might be not a GeoAnalytics question, you should use the following formulas:

For getting the maximum qty value:

=max(aggr(Sum(qty),Country))

For getting the corresponding country:

=FIRSTSORTEDVALUE(Country,-aggr(sum(qty),Country))