Forum Discussion
Normalized area map
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
Ok, it's more easy to understand like this.
First of all, I would create a new table to see things clearer
This table is the number of event and the event per person grouped by country names
Table = SUMMARIZE(Table1;Table1[Country];"Number of events";COUNTA(Table1[EventId]);"Event/Person";DIVIDE(counta(Table1[EventId]) ; sum(Table2[Population)))
Hope this is what you are looking for
- Quentin
Hi Quentin
thank you. It does partially solve my issue. There are two caveats:
- The table data does not consider filters. If I have filters in the page, and I show the table data, the filters does not filter out data. The table consider only the entire data set:
(i.e. the orange filters does not change the red values)
The second issue is that I cannot feed this data to the map control as it accepts only a set of events.
The more I think about the more I believe I cannot do it with this control....
Anonymous
Did you create a link between the tables in the relationship tab ? If there is not relationship there will be no filter working
On your map you need to add to RegionLocal to the field 'Place' (or something with this name) and Number of events in the value/color saturation field
- Quentin
quentin_vigne wrote:Anonymous
Did you create a link between the tables in the relationship tab ? If there is not relationship there will be no filter working
On your map you need to add to RegionLocal to the field 'Place' (or something with this name) and Number of events in the value/color saturation field
- Quentin
On the filtering, you're right, I didn't link the new Summary Table RegionLocal with the original table, and indeed now works. Well, "works" -> Works only if I filter on Regionlocal, but for example if I filter by period, numbers does not change.
This is my link status after your suggestion:
If chose "Regione" filter, and I choose only one region (i.e. "Abruzzo Italia") the table shows correctly only one row.
However the column "number of events" reports always the same number, regardless of the time period that I chose on the top filters.And by the way, I already have the map working, but it's not normalized:
Anonymous
You need to edit the relation between Italy + All and Density and choose bi directionnal filter
You only have a filter from Density to Italy + All so you can't filter the number of event by choosing a date from Italy + All (Hope I'm clear)
On the map you need to display the events/person + Region local (I told you Number of events but that's a mistake from me ...)
- Quentin
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...
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
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: