Forum Discussion
Mapping with multiple data sets
Hi I'm trying to map employee counts over a company on a map. For example my data looks like
| State | Marketing | Sales | Factory | Management | |
| ALABAMA | 160 | 336 | 862 | 28 | |
| ALASKA | 237 | 461 | 576 | 28 | |
| ARIZONA | 115 | 392 | 762 | 14 |
I would like to use a filled map that is filled based on the sum of all employees, but have a slicer that would recolor the map if I only cared about the distribution of a certain kind of employee (e.g marketing, mangement, etc).
Currently I can only have one value as the value used for the mapping, I can easily sum the numbers, but I cannot get the filtering to work.
Any help would be appreciated.
Anonymous,
If I understand correctly, you are trying to seee Filled Map visualization by state and be able to filter by each department (Marketing, Sales, Factory, Management) ?
Let say, I have your sample data:
First, you need to unpivot data to have a tabular structure.
Select State column and go to Transform -> Unpivot Columns -> Unpivot Other Columns
You will get:
Then import the data and create visualization with filter by the new Attribute column:
Let me know if this helps. Thanks.
2 Replies
Anonymous,
If I understand correctly, you are trying to seee Filled Map visualization by state and be able to filter by each department (Marketing, Sales, Factory, Management) ?
Let say, I have your sample data:
First, you need to unpivot data to have a tabular structure.
Select State column and go to Transform -> Unpivot Columns -> Unpivot Other Columns
You will get:
Then import the data and create visualization with filter by the new Attribute column:
Let me know if this helps. Thanks.