I'm using data currently formatted like this:
|Events||Type A||Type B||Type C|
As you can see, some of the events fall into more than one category. I want to plot the events on a map and then allow users to filter events on the map by type. How do I format the data to achieve this?
It is probably best to reshape the data so that each of the types are in the same column. The following KB article should provide some insight on how to prepare a file for analysis:
Hope this helps!