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


      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.