Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Normalized area map

Hi   i'm trying to show density of "people" events per region and it works perfectly fine. The issue however is that these events are not normalized with the density of the population with the regi...
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Hi Anonymous

     

    So here is what I've done with your data : 

    I've created Table1

    ID	EventID	Country
1	12334	USA
2	5678	Italy
3	9545	USA
4	4585	France

    And Table2

    Country	Population
USA	360000000
Italy	60000000
France	67000000

    They have a bidirectionnal filter between them

     

    Then I create a calculated Table3

     

    Table3 = SUMMARIZE(table1;Table1[Country];"Number of events"; counta(Table1[EventID]);"Event/Person";Divide(counta(Table1[EventID]);sum(Table2[Population])))

    And add a bidirectionnal filter between Table2 and Table3

     

    Then I add a map and here what It looks like : 

     

     

    USA is more faded because it has more inhabitants than France and Italy (both of these country have between 60 and 70 M inhabitants so the color is almost the same)

    You need to add Event/Person in the saturation color field and then add Number of Events in the tooltip area (the bottom one called Info-bulles on my screen) so that the end-user can still have it.

     

    - Quentin

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi, this is how it's set and it's not working

(sorry for the italian, but "entrambi" means bidirectional.)

 

Also on the map: as far as i know it expects a number of countable events and a region on each one of them, instead of a row per region with a value...

 

 

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi Anonymous

 

So here is what I've done with your data : 

I've created Table1

ID	EventID	Country
1	12334	USA
2	5678	Italy
3	9545	USA
4	4585	France

And Table2

Country	Population
USA	360000000
Italy	60000000
France	67000000

They have a bidirectionnal filter between them

 

Then I create a calculated Table3

 

Table3 = SUMMARIZE(table1;Table1[Country];"Number of events"; counta(Table1[EventID]);"Event/Person";Divide(counta(Table1[EventID]);sum(Table2[Population])))

And add a bidirectionnal filter between Table2 and Table3

 

Then I add a map and here what It looks like : 

 

 

USA is more faded because it has more inhabitants than France and Italy (both of these country have between 60 and 70 M inhabitants so the color is almost the same)

You need to add Event/Person in the saturation color field and then add Number of Events in the tooltip area (the bottom one called Info-bulles on my screen) so that the end-user can still have it.

 

- Quentin

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Quentin, thanks to your insights and other info, i've been able to make it work. The culprit was the fact that I expected the map control to work with countable events instead of a value per region.

     

    Thanks: