Kumu Tips – Clustering on Multiple-Option Drop-Down Data

blue nodes only

Got This?

A bunch of disconnected survey responses, with nothing to indicate what they have in common. . .

Want This?

To see your people clustered by each separate response,
so you can see everyone who is interested in the same things.

But Opps!!

Are you gettig This?

People clustered by EVERYTHING they chose from the drop-down menu.
Each attached to their own unique combo of options?? Ugh!!!

Let's Fix That!

The problem starts in the spreadsheet you uploaded (of course, those evil %#&%$!<!?@%!!!!!. . .)

Notice how your drop-down options are separated by commas?

“Education, Racial Equity, Economics. . . .”

Each one of those was once a separate option, but your survey tool exported them all in a single column. And those commas aren’t telling Kumu “these are different choices”.
So Kumu thinks the whole spreadsheet cell is one distinct value. See how every cell’s content looks different?

Excel-BothIssues

What we want instead are 'pipes'. . .

These things { | | | } are the solution (don’t ask me where to find it on your keyboard, they’re all different. . .)

Your data SHOULD look like this:

“Education|Racial Equity|Economics. . . .” (easily done with a simple find/replace)

Pipes tell Kumu “These are different choices – separate them out, and start a new row in the sidebar”

Excel-BothIssues-closeup-highlighted

Say, what was that about the sidebar?

Get your data structured right, and everything makes more sense . . .
original sidebar

This looks sort of o.k,

BUT... |

fixed sidebar

Not compared to this...

See the difference between 'issues' and fixed 'issues'

And see how Kelli's interests show up on the map?

Pipes do that. Don't forget your pipes!!

Got Questions?

Go ahead & ask, I like to help. . .

And, what other Kumu tips would you like me to write about?

Leave a Comment

FREE DIY Network Mapping Tool
Subscribe to Our Newsletter

SIGN UP NOW FOR OUR NEWS LETTER

!
!
Something went wrong. Please check your entries and try again.

Wanna be Part of Our Network?

You'll get:

  • Reflections on moving from systems of dominance to systems of connection
  • Technical tips (Kumu, Social Network Analysis, etc.)
  • Reviews and comparisons of tools & platforms for Network Weavers
  • Updates about affordable tools created by Greater than the Sum for your independent use.