Kumu
  • Getting started
    • Welcome
    • Kumu 101
    • First steps
    • Quick tips
    • Webinars
  • Overview
    • Kumu's architecture
    • Accounts and workspaces
    • Kumu.io and Kumu Enterprise
    • Billing
    • User interfaces
      • Dashboard
      • Settings
      • Map editor
      • View editors
      • Quick Actions
    • Collaborating and sharing
    • Actions and permissions
    • Security
    • Advanced Editor hub
      • @settings reference
      • @controls reference
      • Color reference
      • Property reference
      • Selector reference
  • DISCIPLINES
    • SNA / Network Mapping
    • Systems mapping
    • Systems Practice workbook
  • Guides
    • Activity feed
    • Add-ons
      • Disqus
    • Bridge
    • Cluster
    • Controls
      • Cluster control
      • Color-legend control
      • Filter control
      • Focus control
      • Image control
      • Label control
      • Showcase control
      • SNA-dashboard control
      • Tagged-timeline control
      • Text Control
      • Title Control
      • View toggle control
    • Decorations
      • Direct decorations
      • Data-driven decorations
      • Flags
      • Icons
      • Images
      • Label templates
      • Popovers
    • Default view settings
    • Export
    • Fields
      • Computed fields
    • Filter
    • Focus
    • Forking
    • Grids & Guides
    • Import
      • Structure your data for Kumu
      • Excel / CSV
      • Google Sheets
      • JSON / Blueprints
    • Imported views
    • Layouts
      • Fixed
      • Force-directed
      • Remove overlap
      • Scatter
      • Snap-to
    • Legends
    • Licensing
    • Lightbox
    • Loops
    • Metrics
    • Two-factor authentication
    • Pro workspaces
      • Archiving projects
      • Discussions
    • Partial views
    • Presentations
    • Profiles
      • Markdown
    • Project admin
    • Selectors
    • Shapes
    • Share and embed maps
    • Shortcuts
    • Showcase
    • Slugs
    • Table
    • Templates
      • Geo template
    • URLs
    • Views
    • Widgets
  • About Kumu
    • What is Kumu?
    • How does it work?
    • Where can I get help?
  • Enterprise
    • About enterprise
    • Getting started with VMWare
    • Upgrading
    • Configuration
    • Creating user accounts
    • SSH Access
    • Single sign-on
    • Backing up enterprise data
    • Restoring enterprise data
    • Command line utilities
    • Changelog
  • Frequently Asked Questions
    • Does Kumu have a public API?
    • Does Kumu make use of AI?
    • How do I add annotations?
    • How do I add anchors to my map description?
    • How do I add arrows to my connections?
    • How do I add documents to profiles?
    • How do I add more than one element with the same label?
    • How do I add text dropdowns to my map overview?
    • How do I adjust arrow size?
    • How do I avoid duplicating data?
    • How do I change connection curvature?
    • How do I change font color?
    • How do I change font size?
    • How do I change the default for currency fields?
    • How do I change the length or strength of connections?
    • How do I change the order of control options?
    • How do I change the position of my element labels?
    • How do I cite Kumu?
    • How do I collapse duplicate connections?
    • How do I copy a map to another project?
    • How do I control label size while scaling element size?
    • How do I control text wrapping?
    • How do I convert a project from private to public?
    • How do I convert a project from public to private?
    • How do I create dynamic on/off toggles for my map?
    • How do I customize link text in popovers?
    • How do I customize the order of my legend?
    • How do I delete a project, map, or view?
    • How do I delete data from my project?
    • How do I downgrade my subscription?
    • How do I edit virtual elements?
    • How do I get rid of duplicates?
    • How do I hide elements without connections?
    • How do I hide images from the map but keep them in the profile?
    • How do I hide labels on my map?
    • How do I hide the settings button?
    • How do I keep elements from moving?
    • How do I list an element's connections in its profile?
    • How do I make elements transparent?
    • How do I make sense of my receipt?
    • How do I open a sub-system when clicking on an element?
    • How do I remove the Opposite entry from my legend?
    • How do I remove unneeded controls?
    • How do I remove unwanted legend entries?
    • How do I rename my map/view?
    • How do I restructure my adjacency matrix?
    • How do I save my changes in Kumu?
    • How do I select options by default in my control?
    • How do I set a minimum or maximum zoom level for my map?
    • How do I show the Settings button?
    • How do I size elements based on number of connections?
    • How do I transfer a project?
    • How do I update my credit card information?
    • How much data can my Kumu project handle?
    • How do my readers switch between maps and views?
    • My data won't import. What can I do?
    • My Kumu embed is not working. What can I do?
    • My map disappeared. How do I bring it back?
    • My PDF won't export. What can I do?
    • What pricing plans does Kumu have?
    • Where can I find my invoices?
    • Where can I find example Kumu projects?
Powered by GitBook
On this page
  • Sample usages
  • Syntax
  • How to handle column headers

Was this helpful?

Edit on GitHub
  1. Frequently Asked Questions

How do I collapse duplicate connections?

PreviousHow do I cite Kumu?NextHow do I copy a map to another project?

Last updated 1 month ago

Was this helpful?

In some networks, you might want to collapse duplicate connections (i.e. multiple connections between the same pair of elements).

We don't offer this feature directly in Kumu, but we wrote a custom Google Sheets formula called KUMU_COLLAPSE to make it easier to collapse and de-duplicate connections inside your spreadsheet.

To get access to the custom formula, you can open our , then click "File" > "Make a copy" to create your own editable copy of the sheet.

Delete all the example tabs in your spreadsheet, then create a new tab, and put your original connection list in that tab. Be sure to add (ignore) to the tab name to make sure Kumu doesn't try to import it.

Then, add a new tab, and type =KUMU_COLLAPSE( in cell A2 to get started (leaving space in row 1 to add column headers later on).

Sample usages

KUMU_COLLAPSE(A1:J10)

KUMU_COLLAPSE(A1:J10, "mutual")

Syntax

KUMU_COLLAPSE(connections, direction)

Parameter
Description

connections

A cell range containing the list of connections you want to collapse. Note: This cell range should not include the column headers from your original connection list.

direction

The direction ("undirected" or "mutual") that should be assigned to a connection after a duplicate pointing in the other direction is discovered. Defaults to "undirected".

KUMU_COLLAPSE returns the collapsed connection list, without column headers. This result will span across multiple columns and rows.

In addition to the From and To elements for each connection, KUMU_COLLAPSE will include any original profile data that was included in the cell range you passed as the connections parameter.

After that profile data, KUMU_COLLAPSE will include:

  • The number of connections (in either direction) that were found between the From and To elements in the original connection list

  • The direction of the connection. This will be directed if connections in the original dataset only ever travel in one direction. If connections were detected traveling in both directions between a pair of elements, KUMU_COLLAPSE will assign undirected or mutual as the connection direction, depending on what you passed to the direction parameter.

How to handle column headers

Intentionally, KUMU_COLLAPSE doesn't carry over your column headers, and you should not include them in the original cell range you pass as the first parameter to KUMU_COLLAPSE.

Instead, you should copy/paste you original column headers over, placing them in row 1, directly above the result from KUMU_COLLAPSE.

At the end, where KUMU_COLLAPSE lists the number of duplicate connections and the connection direction, you'll have two blank column headers.

For the number of duplicates, it's most common to put Strength as the connection header. For the connection direction, you can put direction in all lowercase letters, and when you import the data, Kumu will understand that you are using that column to .

"With custom Kumu formulas" Google Sheet
add arrows to connections