Skip to main content

Advanced Grouping to Show Differentiation

What are we talking about here?
So basic grouping was, well, a bit basic wasn’t it? When I ran through it with my wife for the first time she was rather impatient and starting asking me why she couldn’t change the pin colors/styles. I explained that she could and that I would walk her through it in the advanced grouping tutorial.

Advanced grouping enables a lot more than simply grouping based on distinct values in a column. With advanced grouping, MapAList supports the use of operators and comparison values to create grouping rules. It then allows you to choose the pin image associated with each group. Let me show you what I mean…

What does it look like from a spreadsheet perspective?

In the sample spreadsheet below (which should look familiar), you can see a column called Response  which is used to differentiate each address as coming to the wedding (Yes), not coming (No), or no response (Empty).  So let’s see what we get when we map this sheet…



What does it look like from a map perspective?

What you can see is that MapAList plotted red pins for addresses that had responded No, Green Pins for addresses that responded Yes, and yellow pins for addresses that did not have a response (empty).  Coincidence on the colors?  I think not.  MapAList’s advanced grouping feature allows the user to choose the pin color/type associated with each group.  I’ll explain how in just a minute.



Okay – so walk me through it step by step…

The process is very much like making a basic map that shows all addresses – the key difference is in Step 4 – Configure Map below:

Step 4 – Configure Map

  • Specify the Setting Type as Advanced – this will give you the opportunity to specify your grouping criteria.
Click on the image to take a closer look
  • Now you can specify your criteria using the simple user interface.  Here’s what I did:
    1. Specified that I want to evaluate the Response column in my worksheet.
    2. Specified that I want MapAList to look for addresses in my worksheet where the value in the Response column is = “equal to” the Comparison Value of No.
    3. Specified in the Criteria Description field that my map key should call these addresses out as Not Attending.
    4. Clicked on the … box and selected the red pin image to use for addresses that are Not Attending.
    5. Clicked on the Plus button to add conditions for my other 2 situations – addresses that are attending and addresses that have no response yet (empty).
Click on the image to take a closer look
  • Click on the Preview Map button to display your map.  The pin images you selected for each condition will display.
  • Click on the Next button.

Step 5 – Save Map

  • Modify Additional Settings as you see fit.
  • Click on the Save & View Map button.
  • Click on the Close This, and Create New Map button.

Give it a try and let us know what you think...

--The Map Commissioner (E-mail)

Popular posts from this blog

New Video Tutorials (Updated)

We decided to experiment and create some video tutorials in the hope they might be more effective instruction and better at getting the word out about what features exist in mapalist and how to utilize them. We hope you find value in the first few we put out. Creating your First Map Using Custom Icons Starting from an Excel Sheet Editing your Maps, Post-Creation Syncing your Map and Google Sheet

Taking your Maps to the Next Level

As our user count has steadily grown, the MapAList support team has received an increasing number of calls and e-mails from users looking to do more with our solution. Over 80% of the feature requests we’ve received are, well, features that already exist within the base MapAList solution. What does that tell us? What it tells me is that we need to do a better job articulating the feature set MapAList has to offer out of the box...and that’s exactly what we’re going to do. For the next several weeks we will be publishing installments of Taking Your Maps to the Next Level – a series of short tutorials meant to enable you, the user, to get more out of MapAList. Each installment will focus on a single feature, show examples of both spreadsheets and maps, and provide step by step instructions to make it work. Here’s the current plan… 01/02/09 – Basic Grouping to Show Differentiation 01/09/09 – Advanced Grouping to Show Differentiation 01/16/09 – Adding Hyperlinks to Your Map Points 01/23/0

Allow your Member/User Base to Add Pins to your Map Using Google Forms

As the MapAList user base has grown over the past couple of years, one of the things we’ve noticed is that we have a ton of organizations leveraging our toolset to map their member/user bases. Religious organizations use MapAList to track their congregations; alumni associations use MapAList to track their members; campaigns and non-profits use MapAList to track their supporters/donors…you get the point. The reason I bring this up is because a few of these organizations have gotten smart and realized that they could push the work of updating their maps out to the user based directly using Google Forms. It’s like self check-out at the grocery store – the users love it because they are empowered (and because it’s a novelty to scan those barcodes) and so does the store because it reduces labor. Sounds cool – right? Well, implementing such a solution on your site with MapAList is not terribly difficult. Those folks at Google have made Google Forms easy to design and feed to a G