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
  • Video explanation
  • Sample usages
  • Syntax
  • Renaming the "Strength" column

Was this helpful?

Edit on GitHub
  1. Frequently Asked Questions

How do I restructure my adjacency matrix?

PreviousHow do I rename my map/view?NextHow do I save my changes in Kumu?

Last updated 8 months ago

Was this helpful?

If your data is structured as an , the matrix will need to be restructured as a list of connections, before it can be . Restructuring an adjacency matrix can be complex, so we created a tool to help you.

It's a custom Google Sheets formula called KUMU_CONNECTION_LIST that will convert any adjacency matrix into a connection list, which can then be imported into Kumu.

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 matrix in that tab. Be sure to add (ignore) to the tab name to make sure Kumu doesn't try to import it. Next, add a new tab, and type =KUMU_CONNECTION_LIST( in cell A1 to get started.

Video explanation

Sample usages

KUMU_CONNECTION_LIST(A1:J10)

KUMU_CONNECTION_LIST(A1:J10, TRUE, TRUE, TRUE, TRUE, TRUE)

Syntax

KUMU_CONNECTION_LIST(matrix, is_directed, include_duplicate_connections, include_self_connections, include_zero_strength_connections, include_blank_strength_connections)

Parameter
Description

matrix

The cell range containing the adjacency matrix to be converted

is_directed

TRUE when the network is directed, FALSE when the network is undirected.

Defaults to FALSE.

include_duplicate_connections

For directed networks: TRUE when the connection list should include connections with the same source and target, FALSE when the connection list should only include the the first connection for any given source-target pair (ignoring all other connections between that pair).

For undirected networks: TRUE when the connection list should include multiple connections between the same pair of elements, FALSE when the connection list should only include the the first connection for any given pair of elements.

Defaults to FALSE.

include_self_connections

TRUE when the connection list should include connections between any given element and itself, FALSE when it shouldn't.

Defaults to FALSE.

include_zero_strength_connections

TRUE when the connection list should include connections whose strength is 0, FALSE when it shouldn't.

Defaults to FALSE.

include_blank_strength_connections

TRUE when the connection list should include connections whose strength is blank, FALSE when it shouldn't.

Defaults to FALSE.

KUMU_CONNECTION_LIST returns the full connection list, which will span across multiple columns and rows.

Renaming the "Strength" column

The KUMU_CONNECTION_LIST formula will store your connection strengths in a column titled "Strength", and "Strength" will become a field name in Kumu. If you want to use a field name other than "Strength" you can follow these steps to change the column header in Kumu:

  1. Add (ignore) to the tab that contains your new connection list, and add a new tab

  2. In cell A2 of the new tab, copy/paste the following formula:

=ARRAYFORMULA('My other tab (ignore)'!A2:C)

Replace My other tab (ignore) with the actual name of the tab where your connection list is. 3. Enter From and To as the column headers in cells A1 and B1 4. Enter your custom Strength column header in cell C1

adjacency matrix
imported
"With custom Kumu formulas" Google Sheet
Note: the first tool in this video is currently unavailable. Please refer to the second tool (custom Google Sheets) at 01:41 of the video.