Mapping with multiple data sets

[Anonymous]

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 · Accepted solution]

@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. 

[Anonymous]

You're an absolute saint. The whole pivoting thing is something I'm still trying to grasp. 

Thanks, 

Chris