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
  • Build section
  • * Gauge value:
  • Minimum Value field
  • Maximum Value field
  • Target Value field
  • Tooltip field
  • Customizing Your Chart
  • Adding Ranges to Your Radial Gauge Chart
  1. Analysing your data
  2. Reports
  3. Build Using Tables
  4. Visualizations

Radial gauge chart

A Radial Gauge Chart is a circular visual that shows how a value (like sales, profit, or website traffic) compares to a minimum, maximum, or target value. It’s a quick and easy way to see if you're on track.

Build section

* Gauge value:

  • This is the main number you want to show on the chart and is mandatory to add.

  • Choose a measure column with the data you want to visualize.

  • Pick how you want among the various aggregation options like SUM, Count, Count (Distinct), AVG etc.

Minimum Value field

  • This field is optional & is also a numeric fields.

  • By default/Auto, the minimum value field will is set to "0". (When no value has been typed-in/no column has been dropped here)

  • You can either drag & drop a field, or type in value here.

  • In case you add a measure column, you can choose from the same aggregation options as mentioned before.

  • In case you want to type-in the max value, you will need to remove the column from the field first (if added).

  • If no column was added, then you can directly type in a numeric value or use arrow icons to increase/decrease the number.

Maximum Value field

  • This field is also optional & numeric.

  • By default, the Maximum value field is set to 200% or twice of the Value that was dropped in "Gauge Value field".

    • Eg: if Revenue was dropped in Gauge value field, and the total revenue was 10M, the maximum value when in default/Auto state be set to 20M.

  • It will show a placeholder of "Auto " in the field.

  • You can either drop a field here, or type in value here.

  • You can either drop in a table or type in a value here.

Target Value field

  • This field is also be optional & numeric

  • User can either drag-&-drop a field here, or type-in value here.

  • In case column is dropped same aggregation options are to be provided as value field.

Tooltip field

  • This is also an optional & numeric field.

  • You can see all aggregate options like other fields.

  • By default, if any column is dropped in any of the other fields, it should show up in the tooltip while hovering over the chart.

  • In tool-tip section, any other field can also be dropped for which you wants to see the tooltip for.

Customizing Your Chart

General Settings:

  • Style: Choose if you want a half-circle or three-quarter circle gauge.

  • Fill Color: Pick the color for the filled part of the gauge.

  • Decal Pattern: Add a pattern to the filled part for better visibility.

  • BG Ring Color: Choose the color for the background ring of the gauge.

  • Ring Width: Adjust the thickness of the gauge ring.

  • Value Indicator: Show or hide a needle pointing to the gauge value. You can also change its style and color.

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.

Gauge Value:

  • Callout Value: Customize how the main value is displayed (font, number format, units, etc.).

  • Label: Add a label below the main value.

Target Value:

  • Target Line: Adjust the appearance of the target line (width, color).

  • Value: Customize how the target value is displayed (font, number format, units, etc.).

  • Label: Add a label for the target value.

Data/Radial Labels:

  • Choose if you want to show labels for the start, end, or all major points on the gauge.

  • Position the labels inside or outside the gauge.

  • Customize the appearance of the labels (font, number format, units, etc.).

Ticks:

  • Control the number, size, and color of the major and minor lines on the gauge.

Adding Ranges to Your Radial Gauge Chart

Understanding Ranges

Ranges in a radial gauge chart divide the chart into segments based on specific values. This helps visualize data distribution and performance against predefined thresholds.

Creating and Editing Ranges

  • Under format -> Ranges -> Enable the ranges with the toggle button

  • Access the Edit Ranges Modal by clicking on ranges dropdown.

  • Choose a Color Scale: Select a color scheme for your ranges from the dropdown options including various gradient and divergent scales.

  • Manage Ranges:

    • Number of Ranges: Adjust the number of ranges by typing a value or using the increment/decrement arrows. The minimum number of ranges is 2.

    • Range Settings: Each range has two main settings:

      • Ring Percent: Determines the percentage of the gauge covered by the range. By default, ranges are evenly distributed.

      • Color: Choose a color for the range. You can select a color from the available options or customize it.

PreviousHeat MapNextAdvanced Features

Last updated 8 months ago

πŸ†•