2 Replies Latest reply on Jul 29, 2016 12:55 PM by Kacem Boukraa

    How create a map with columns associated with city names

    Kacem Boukraa

      Hello everybody,

       

      I have an issue understanding how to achieve the following point:

       

      I have a fact table named "stats_cities" that contains columns related to diff cities for many stores, like this.

       

      DateStore_IDLondonLos angeles
      BerlinMadrid
      22-07-201613365634
      23-07-201615636435

       

      Each row is generated once per day and is associated with many cities for a given store, the list of cities is fixed. What i want to achieve is a map representation of the sum of each city, meaning that for London i want to add it to a map where the sum(33+56) is presented. the same for Los Angles and other cities, All in the same map.

       

      Is it possible to achieve such a goal? should i perform any modification in my data representation otherwise?

       

      Thanks in advance.