Orange question mark icon that reads Quick Reference Guide
MAPLINE DATA:
FROM ANY DATASET

Take your data to the next level by leveraging any of your existing datasets in Mapline.

This is a powerful way to bring in data from any dataset and use it wherever you need it in Mapline. Check it out!

SELECT CALCULATION TYPE

Click the drop-down menu to select the type of calculation you need. These are powerful ways to auto-calculate information based on what’s already contained in your dataset!

Get ready to level-up your data analysis game as we dive in to each type of calculation and how to configure your formulas.

DISTANCE TO ANOTHER LOCATION IN THIS DATASET

Find the straight-line or driving distance between two locations in your dataset.

Straight-line distance is the shortest path between two points on a map.

Driving distance calculates the distance based on real-world routes.

Use this calculation to optimize logistics, estimate travel times, and understand the distance between locations.

DRIVE TIME TO ANOTHER LOCATION IN THIS DATASET

Find the straight-line or driving distance between two locations in your dataset.

Straight-line distance is the shortest path between two points on a map.

Driving distance calculates the distance based on real-world routes.

Use this calculation to optimize logistics, estimate travel times, and understand the distance between locations.

CELL VALUE OF ANOTHER ROW IN THIS DATASET

Perform calculations based on the value of a cell from another row in your dataset.

This feature allows you to use information from one row to calculate something in another row. Uncover insights and create new information easily by referencing different parts of your dataset.

COUNT SPECIFIC ROWS IN THIS DATASET

Get the number of specific rows or unique values in your dataset. This calculation helps you understand occurrences, patterns, and the overall distribution of data.

AGGREGATE VALUES OF SPECIFIC ROWS IN THIS DATASET

Combine values from different rows to calculate sums, averages, medians, maximums, minimums, or unique values. This calculation helps you summarize and analyze data across multiple rows, providing a clearer picture of your dataset.

ASSIGN A CATEGORY TO EACH ROW IN THIS DATASET USING FILTER CRITERIA

Organize your dataset by assigning categories based on specific conditions. Group and sort your data to gain better insights and make smarter decisions.

CALCULATE A VALUE FOR EACH ROW IN THIS DATASET USING A FORMULA

Use custom formulas or equations to calculate values for each row in your dataset. This powerful feature allows you to perform complex calculations effortlessly, unlocking the full potential of your data.

ASSIGN A GROUP TO EACH ROW IN THIS DATASET

Group cells in your dataset based on assigned categories. Organize and visualize your data by creating clusters or groups, enabling easier analysis of specific subsets.

NUMBER THE ROWS IN THIS DATASET

Automatically assign unique numbers to each row in your dataset. This calculation provides a simple way to identify and refer to specific data points, keeping your information organized and accessible.

META INFORMATION ABOUT EACH ROW IN THIS DATASET

Access additional information about each row in your dataset, such as creation and modification dates, creator name, or the Mapline record ID. Maintain data accuracy and integrity with a clear audit trail of each row’s history and origin.