Using different strings for key and label of RAVE map

[paju91]

Hey everyone,

I have another question regarding RAVE visualizations. I'm using one to display a map showing some geographical information about countries and cities. In my database every country/city has a technical key like 'c01' and a label name like 'Singapore'. The GeoJSON information in the RAVE visualization contains the technical keys to match the points/polygons. In the Active Report I would like to use the label names to be shown. When adding additional fields to the country data I only manage it to be either a numeric fact value oder an additional category. What I want is a 1:1 relationship to the existing key category.

Here some of my code:

Code Select Expand


"data":
   [
      {
         "fields":
         [
            {
               "label":"country key",
               "id":"country_key",
               "categories":
               [
                  "c01",
                  "c02",
                  "c03"
               ]
            },
            {
               "label":"country label",               //I have no idea what to do here
               "id":"country_label",           
               "format":{}
            },
            {
               "label":"Average income",
               "format":
               {
                  "numericPattern":"######.##"
               },
               "id":"country_avg_inc"
            }
         ],
         "rows":
         [
            [
               0,
               1
            ],
            [
               1,
               2
            ],
            [
               2,
               3
            ]
         ],
         "id":"country_data"
      },...


and here the augment part:

Code Select Expand


"augment":
   [
      {
         "method":"includeAllSource",
         "target":
         {
            "$ref":"country_data"
         },
         "source":
         {
            "$ref":"country_resource"
         },
         "dataKeys":
         [
            {
               "$ref":"country_key"
            }
         ],
         "sourceKeys":
         [
            "country_key"
         ]
      },...


I attached an IBM sample visualization with a map of Germany.

Thanks for your support!

Greetings

paju