Sprinkle Docs
  • What is Sprinkle?
  • Quick Start
  • Analysing your data
    • 🔭Analytics Overview
    • 💠Data Models
      • *️Variables
      • 🌲Hierarchies
      • 🤿Column Mask
    • 🎉Switch to New Reports & Dashboards
    • 🆕Reports
      • Overview
      • Build Using Tables
        • Create a new Report
        • Layout and options
        • Build and Format - Overview
        • Apply Row Limits
        • Identify Date Columns
        • Filter your data
        • Visualizations
          • Table
          • Pivot
          • Line Chart
          • Bar Chart
          • Column Chart
          • Area Chart
          • Combo Chart
          • Scatter & Bubble Plot
          • Pie Chart
          • Funnel Chart
          • Stat Card
          • Point Map
          • Heat Map
          • Radial gauge chart
        • Advanced Features
          • Custom Analysis
          • Variables
          • Table & Quick Calculations
          • Drill - Hierarchical & Date
          • Break Out
          • RLS in Table reports
          • Scheduled Exports
          • Embedding Table Reports
      • Build Using Models
        • Create a new report
        • Layout and options
        • Visualizations
        • Advanced Features
      • Build SQL Reports
        • Create a new Report
        • Layout and options
        • Writing a SQL Code on Editor
        • Visualizations
        • Variables in SQL Reports
    • 🆕Dashboards
      • 🌀Filters
      • 👆Click Behaviour
      • ⏰Data Alerts
      • 🗓️Date Drill
      • 📤Scheduled Exports
      • 🔗Embed link
      • 🖥️Dashboard layout
      • 📱Mobile Dashboards
  • Transforming your data
    • 🔰SQL Transform
    • 📓Python Notebooks
  • Integrating your data
    • ☁️Destination Warehouses
      • AWS Athena
        • Manage storage of Flow tables
      • AWS Redshift
      • Azure Synapse
      • Databricks
      • Google BigQuery
      • MySQL
      • Postgres
      • Snowflake
      • SQL Server
      • K8 Setup
        • AWS EKS
        • Google GKE
        • Azure AKS
    • ⚙️Warehouse & Storage Setup
  • Ingesting your data
    • ☄️Data Imports
      • Databases
        • Azure Cosmos DB
        • Azure Table Storage
        • Google BigQuery
        • Mongo DB
        • MySQL DB
        • Oracle DB
        • Postgres DB
        • SQL Server DB
        • Features
          • Ingestion Modes
          • Add Multiple Datasets
          • CDC Setup
            • CDC setup in Mysql
            • CDC setup in Postgres
            • CDC setup in Mongo
            • CDC setup in SQL Server
          • Destination Create Table Clause
          • SSH Tunnel Setup
      • Files
        • AWS S3
        • AWS S3 External
        • Azure Blob
        • FTP
        • Google Cloud Storage
        • Google Sheet
        • SFTP
      • Applications
        • Apple Search Ads
        • Appsflyer
        • Branch
        • Clevertap
        • Facebook Ads
        • Freshdesk
        • Freshsales
        • Google Ads
        • Google Ads V2
        • Google Analytics
        • Google Analytics 4
        • Google Analytics MCF
        • Google Search Console
        • Hubspot
        • Impact Ads
        • Intercom
        • Klaviyo
        • Leadsquared
        • LinkedIn Ads
        • Magento
        • Mailchimp
        • Marketo
        • Mixpanel
        • MoEngage
        • Rocketlane
        • Salesforce
        • SAP S4
        • Shopify
        • Snapchat Marketing
        • TikTok Ads
        • WooCommerce
        • Zendesk Chat
        • Zendesk Support
        • Zoho Analytics
        • Zoho Books
        • Zoho CRM
        • Zoho Desk
        • Zoho Invoice
        • Zoho Subscription
      • Events
        • Apache Kafka
        • AWS Kinesis
        • Azure EventHub
    • 📤File Uploads
    • 🤖API Pulls
    • 🕸️Webhooks
  • Collaborating on data
    • 📤Sharing
    • 💬Comments
    • ⚡Activity
    • 🏷️Labels
  • Managing Schedules and Data Refreshes
    • ⏱️Schedules
    • 🔔Notifications
  • User Management
    • 🔑Access Management
    • 🧑‍🤝‍🧑Groups
    • 📂Folders
    • 🔄Syncing users, groups and RLS
    • 📧Azure AD Integration
  • Data Security & Privacy
    • 🔐Security at Sprinkle
    • 📄GDPR
    • 📄Privacy Policy
  • Release Notes
    • 📢Release Notes
      • 🗒️Release Notes - v12.1 (New)
      • 🗒️Release Notes - v12.0
      • 🗒️Release Notes - v11.0
      • 🗒️Release Notes - v10.8
      • 🗒️Release Notes - v10.7
      • 🗒️Release Notes - v10.6
      • 🗒️Release Notes - v10.5
      • 🗒️Release Notes - v10.4
      • 🗒️Release Notes - v10.3
      • 🗒️Release Notes - v10.2
      • 🗒️Release Notes - v10.1
      • 🗒️Release Notes - v10.0
      • 🗒️Release Notes - v9.31
      • 🗒️Release Notes - v9.30
      • 🗒️Release Notes - v9.29
      • 🗒️Release Notes - v9.28
      • 🗒️Release Notes - v9.27
      • 🗒️Release Notes - v9.25
      • 🗒️Release Notes - v9.24
      • 🗒️Release Notes - v9.23
      • 🗒️Release Notes - v9.22
      • 🗒️Release Notes - v9.21
      • 🗒️Release Notes - v9.20
      • 🗒️Release Notes - v9.19
      • 🗒️Release Notes - v9.18
      • 🗒️Release Notes - v9.17
      • 🗒️Release Notes - v9.16
      • 🗒️Release Notes - v9.14
      • 🗒️Release Notes - v9.13
      • 🗒️Release Notes - v9.12
      • 🗒️Release Notes -v9.8
      • 🗒️Release Notes - v9.7
      • 🗒️Release Notes - v9.6
      • 🗒️Release Notes - v9.5
      • 🗒️Release Notes - v9.4
      • 🗒️Release Notes - v9.3
      • 🗒️Release Notes - v9.2
      • 🗒️Release Notes - v9.1
      • 🗒️Release Notes - v9.0 (Major)
      • 🗒️Release Notes - v7.23
      • 🗒️Release Notes - v7.21
      • 🗒️Release Notes - v7.20
      • 🗒️Release Notes - v7.15
      • 🗒️Release Notes - v7.14
      • 🗒️Release Notes - v7.13
Powered by GitBook
On this page
  • Building Your Point Map
  • * Location
  • * Latitude & Longitude:
  • Color by (Optional)
  • Size (Optional)
  • Tooltip (Optional)
  • Formatting Your Point Map
  • Labels
  1. Analysing your data
  2. Reports
  3. Build Using Tables
  4. Visualizations

Point Map

Point maps are a visualization tool designed to effectively represent quantitative data associated with specific geographic locations.

This visualization is particularly useful for datasets where data points are linked to precise coordinates.

Building Your Point Map

To create a point map, you must provide the following information:

* Location

  • Specify the geographic location of your data points (e.g., city, country, continent).

  • Once a field is dropped, select its appropriate geographic role from the dropdown menu.

OR

* Latitude & Longitude:

Provide the exact coordinates for each location.

Drag latitude (y) and longitude (x) fields to define map coordinates.

These fields must be of decimal data type and classified as measures.

Color by (Optional)

  • Use this field to categorize data points using color.

  • You can apply color based on numeric or categorical data.

Size (Optional)

Use this field to represent data points as bubbles of varying sizes. The field should be a measure, and you can use aggregations like COUNT or DISTINCT.

Tooltip (Optional)

Add additional fields to display detailed information when hovering over a data point. Multiple fields can be included.

Formatting Your Point Map

Title

This allows you to give a Title to the Line Chart. You just need to go to the Title section in the Format panel.

You can easily toggle it on or off. In the "Customize title" modal, you can:

  • Modify the title text, font size, and alignment, and even add a background color.

  • Include an optional description that will appear when hovering over the "i" icon that will be visible as a floating button on the tile.

Once done, click the Apply button.

Map Display Settings

  • Map background style: Choose from Normal, Light, Dark, Street, Outdoors, or Satellite.

  • Bubbles: Adjust the size of data points using a slider with values ranging from 1 to 100.

Colors

  • Case 1: Default color: If no field is assigned to "Color by," you can change the default bubble color using the color picker or predefined color options.

  • Case 2: Color by value: Assign the same field to both "Color by" and "Size" to create a color scale based on data values. Customize the color scale using the edit color scale modal.

  • Case 3: Color by category: Assign a categorical field to "Color by" to apply distinct colors to different categories. Choose from predefined color palettes or create a custom gradient scale.

Legend

  • This allows you to showcase the chart legend.

  • By default it is disabled. But you can easily enable it by clicking on the Show Legend toggle button under the legends section under the format panel.

  • Choose from a variety of positions, including top, bottom, left, and right, with options for stacking and centering.

  • For charts with many legends, you can easily scroll through them.

  • Additionally, you can customize the font size, color, family, and style of legend text to match your chart's design.

Labels

It allows you to enable/disable the visibility, the appearance & the layout of data labels. By default, it will be disabled. You can turn on the labels using the toggle switch.

Global Label Settings

Apply consistent formatting to all labels within a chart.

You can customize:

  • Layout: Position, alignment, overflow, and rotation etc.

  • Content: Display values, series names, or categories.

  • Appearance: Font, color, background, and number formatting etc.

Specific Label Settings

Tailor labels for individual data points or categories.

Ideal for highlighting specific data or creating visual distinctions.

To add specific formatting:

  • Add the specific label from the dropdown

  • Click on the fields to make them editable and change the values according to your requirements.

  • Apply the changes. These changes will override the global settings.

Example: Display percentages as labels for one series, while showing values for another.

Tooltip

Here all the fields that are added in the build section will be shown.

You can use to checkboxes to choose which fields users want to keep in the tooltip.

PreviousStat CardNextHeat Map

Last updated 9 months ago

🆕