Route Map Edge Case: Ability to remove lines between points while still retaining Point 1/Point 2
Hello!
I have an edge case on a map I'm creating. The Lat/Long Route Map I saw seemed perfect for the customer I building this for, but then they provided feedback saying they want the symbols/dots but they do not want the lines going between the dots. I do not believe there is an ability to remove the lines/routes between the dots unless I'm missing something? The key here is I have separate lat/long points where if my user selects an origin point, they want to see dots representing the potential destinations. The lines would clutter the map too much. I can't use a regular lat/long map because it doesn't accommodate filtering well for origin/destination points.
If I can't do it via the base product, is there a brick that someone has used that they'd recommend for this? Below is a screenshot of my map. Idea is origin points are in the blue/grey and destination points are green (this is a snippet of the dataset used to mock it into a dashboard).
Here's a snippet of the data I'm using, sensitive data redacted:
Best Answer
-
You could use Origin as the 'Series for Color' in the Lat/Long map. This would tie the origins to their destinations, so when you hover on an origin, all the destinations would appear, and you could click to filter by that series.
You'd want to restructure your data a bit. In a magicETL, you could select all of your origin columns, add a column of destinations that's just duplicate of the origin (formula tile), then append that dataset to the bottom of all the destination columns (rename Long and Lat to match in the appended datasets). The data would look like:
Origin (series) | Destination (label) | Long | | Lat
I didn't address you wanting to color origins one thing and destinations something else. You could differentiate by size instead. Sizing by count will make the origins significantly larger than the destinations, hopefully making them look like hubs surrounded by their same-color destinations.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
You could use Origin as the 'Series for Color' in the Lat/Long map. This would tie the origins to their destinations, so when you hover on an origin, all the destinations would appear, and you could click to filter by that series.
You'd want to restructure your data a bit. In a magicETL, you could select all of your origin columns, add a column of destinations that's just duplicate of the origin (formula tile), then append that dataset to the bottom of all the destination columns (rename Long and Lat to match in the appended datasets). The data would look like:
Origin (series) | Destination (label) | Long | | Lat
I didn't address you wanting to color origins one thing and destinations something else. You could differentiate by size instead. Sizing by count will make the origins significantly larger than the destinations, hopefully making them look like hubs surrounded by their same-color destinations.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive