The Google Chart offers a powerful tool to visualize data points with precision, both on a global and national scale. With its advanced functionalities, you can gain an expansive view of ongoing projects spanning continents or zoom into specific regions to gain insights into critical events. Such visibility is especially invaluable for businesses, as identifying potential breaking points early on can prevent disruptions in your supply chain, ensuring smoother operations.
Beyond its visualization capabilities, the Google Chart streamlines your data interaction experience. With its intuitive interface, you can highlight key records on a single screen and, with just a click, delve deeper into the data, accessing meaningful information in mere seconds. This seamless integration between a high-level overview and granular details ensures that you remain informed, agile, and ready to make data-driven decisions promptly.
- Basic Configuration
- Chart Configuration
- Dual Reports
- Base Filter
- Report Visibility
To generate a Google Map Chart, you first need to be in the 'Reports' section where you will then be able to click 'Add Report' in at least one of the highlighted locations below.
By clicking the button it should bring you to a report selection page where you are shown various reports and some information about them. To choose a 'Google Map Chart' find the card containing the 'Google Map' chart then click on 'Create'. Alternatively, you can find it by searching and selecting 'Google Map' on 'Filter Types'.
To see more on the Basic Information, please click here
The Chart fields are the fields that make up the information that displays on the Google Map Chart. To add a new Chart Field click on the 'Add Chart Field' button and to remove a Chart Field click on the cross at the end of the row for the field you want to remove. There are a number of options that can be set for each Chart Field.
Label: The label acts as an identification tool for app builders. It's designed to help you swiftly identify the purpose or content of a specific field, such as "Company Title". Importantly, it remains hidden from the workspace UI and is solely for internal referencing.
Latitude: This specific chart field points to the data field containing latitude coordinates. It's essential that the chosen field is numeric. If you need to convert locations to latitude and longitude coordinates, click here.
- Tip: To prevent data errors, set constraints on the numeric field: the minimum value should be -90 and the maximum should be 90.
Longitude: This chart field indicates the field storing longitude coordinates and, like the latitude, it must be numeric. For location-to-coordinate conversions, click here.
- Tip: Ensure valid entries by setting a range for the numeric field: minimum value is 0 and the maximum is 180.
- Suggestion: When users input latitude and longitude coordinates, consider embedding an image action button linking to the aforementioned location converter. For a deep dive into image action buttons, click here.
Colour: Define the colour of the map pin using this field. The colour can serve as a visual indicator, reflecting statuses like project phases or audit results. Accepted values for this multistate field include Grey, Green, Amber, Red, Black, and Blue.
Title: Upon clicking a map pin, a pop-out appears. The title is the bolded text at the top of this pop-out. As it's displayed prominently, it's ideal to link this to a concise data field, like a title or company name, ensuring it doesn't overwhelm the pop-out space.
Description: Occupying the central portion of the pop-out, this field can accommodate detailed information. Long text fields are optimal here, granting flexibility for extensive content. Another approach? Merge multiple data fields into one long-text descriptor, like an address compilation.
Link Name: Within the map pin's pop-out, this textual element is more than meets the eye. It embeds a URL, turning a simple name, like a company's, into an actionable link. If you're leveraging this field, the complementary Link URL is a must-have.
Link URL: This field ensures the Link Name isn't merely text—it's an interactive portal. Always choose a URL-specific field for this purpose to guarantee valid web addresses. And remember, it's a package deal; if the Link URL is active, the Link Name should be too.
If additional data and context would enhance the report's insights, the dual report feature can seamlessly incorporate a table report below the chart. This table report, designed to complement the chart, offers an opportunity to present data in a more detailed format. To align these components effectively, the table report's filters can be synchronized with the chart's filters, ensuring coherence in the displayed information. For guidance on configuring dual reports for optimal results, refer to our support article linked here.
If the report is to always show a subset of records, then the base filter can be used to apply a permanent filter to the report. This filter is always applied, and then user-defined filters and searches are defined on top when the report is being used - For more about configuring base filters click here
Similar to how app visibility works this can be set to hide your reports from certain users or teams, which can be great for hiding reports from certain teams or guests - For more about configuring Report Visibility click here
Make sure to click the 'Save' button when making any changes in order for them to be added to the next app version. Once you have made all the changes you need to an application you are then ready to publish it to workspace.
Note: This report type is not available in dashboards