Hi everyone,
We're looking for a way to generate map legend ranges dynamically based on the actual KPI values displayed on a Board map.
The KPI is a calculated metric used in the map. The goal is to determine the minimum and maximum KPI values across all displayed territories and automatically create 5 equal classes for the legend.
For example:
- Minimum value: 11.4
- Maximum value: 37.7
The class width would be calculated as the difference between maximum and minimum divided by 5.
The customer described it as:
- a = (Maximum value − Minimum value) / 5
- b = 2 × a
- c = 3 × a
- d = 4 × a
- e = 5 × a
Resulting in ranges such as:
- 11.4 – 16.7
- 16.7 – 21.9
- 21.9 – 27.2
- 27.2 – 32.4
- 32.4 – 37.7
What we've found so far:
max(), min(), dt(), etc. do not seem to return the global minimum/maximum across all territories.- They appear to work within the current evaluation context/cell rather than across the entire displayed set.
- The correct MIN/MAX values are visible in aggregated results, but we have not found a way to reuse those values in further calculations for the legend.
Our questions are:
- Is there a way in Board 14 to retrieve the global MIN and MAX of a KPI across all members of an entity directly in a Data View?
- Can this be achieved with NEXEL, for example by referencing ranges or total cells?
- Has anyone implemented a dynamic map legend like this without using a helper cube and a procedure/dataflow?
Our current fallback idea is to store MIN and MAX in a small helper cube and calculate the legend ranges from there, but we're interested in knowing whether a more native solution exists.
Thanks!
Carolin
