HEAVY.AI Docs
v8.1.0
v8.1.0
  • Welcome to HEAVY.AI Documentation
  • Overview
    • Overview
    • Release Notes
  • Installation and Configuration
    • System Requirements
      • Hardware Reference
      • Software Requirements
      • Licensing
    • Installation
      • Free Version
      • Installing on Docker
        • HEAVY.AI Installation using Docker on Ubuntu
      • Installing on Ubuntu
        • HEAVY.AI Installation on Ubuntu
        • Install NVIDIA Drivers and Vulkan on Ubuntu
      • Installing on Rocky Linux / RHEL
        • HEAVY.AI Installation on RHEL
        • Install NVIDIA Drivers and Vulkan on Rocky Linux and RHEL
      • Getting Started on AWS
      • Getting Started on GCP
      • Getting Started on Azure
      • Getting Started on Kubernetes (BETA)
      • Upgrading
        • Upgrading HEAVY.AI
        • Upgrading from Omnisci to HEAVY.AI 6.0
        • CUDA Compatibility Drivers
      • Uninstalling
      • Ports
    • Services and Utilities
      • Using Services
      • Using Utilities
    • Executor Resource Manager
    • Configuration Parameters
      • Overview
      • Configuration Parameters for HeavyDB
      • Configuration Parameters for HEAVY.AI Web Server
      • Configuration Parameters for HeavyIQ
    • Security
      • Roles and Privileges
        • Column-Level Security
      • Connecting Using SAML
      • Implementing a Secure Binary Interface
      • Encrypted Credentials in Custom Applications
      • LDAP Integration
    • Distributed Configuration
  • Loading and Exporting Data
    • Supported Data Sources
      • Kafka
      • Using HeavyImmerse Data Manager
      • Importing Geospatial Data
    • Command Line
      • Loading Data with SQL
      • Exporting Data
  • SQL
    • Data Definition (DDL)
      • Datatypes
      • Users and Databases
      • Tables
      • System Tables
      • Views
      • Policies
      • Comment
    • Data Manipulation (DML)
      • SQL Capabilities
        • ALTER SESSION SET
        • ALTER SYSTEM CLEAR
        • DELETE
        • EXPLAIN
        • INSERT
        • KILL QUERY
        • LIKELY/UNLIKELY
        • SELECT
        • SHOW
        • UPDATE
        • Arrays
        • Logical Operators and Conditional and Subquery Expressions
        • Table Expression and Join Support
        • Type Casts
      • Geospatial Capabilities
        • Uber H3 Hexagonal Modeling
      • Functions and Operators
      • System Table Functions
        • generate_random_strings
        • generate_series
        • tf_compute_dwell_times
        • tf_feature_self_similarity
        • tf_feature_similarity
        • tf_geo_rasterize
        • tf_geo_rasterize_slope
        • tf_graph_shortest_path
        • tf_graph_shortest_paths_distances
        • tf_load_point_cloud
        • tf_mandelbrot*
        • tf_point_cloud_metadata
        • tf_raster_contour_lines; tf_raster_contour_polygons
        • tf_raster_graph_shortest_slope_weighted_path
        • tf_rf_prop_max_signal (Directional Antennas)
        • ts_rf_prop_max_signal (Isotropic Antennas)
        • tf_rf_prop
      • Window Functions
      • Reserved Words
      • SQL Extensions
      • HeavyIQ LLM_TRANSFORM
  • HeavyImmerse
    • Introduction to HeavyImmerse
    • Admin Portal
    • Control Panel
    • Working with Dashboards
      • Dashboard List
      • Creating a Dashboard
      • Configuring a Dashboard
      • Duplicating and Sharing Dashboards
    • Measures and Dimensions
    • Using Parameters
    • Using Filters
    • Using Cross-link
    • Chart Animation
    • Multilayer Charts
    • SQL Editor
    • Customization
    • Joins (Beta)
    • Chart Types
      • Overview
      • Bubble
      • Choropleth
      • Combo
      • Contour
      • Cross-Section
      • Gauge
      • Geo Heatmap
      • Heatmap
      • Linemap
      • Number
      • Pie
      • Pointmap
      • Scatter Plot
      • Skew-T
      • Table
      • Text Widget
      • Wind Barb
    • Deprecated Charts
      • Bar
      • Combo - Original
      • Histogram
      • Line
      • Stacked Bar
    • HeavyIQ SQL Notebook
  • HEAVYIQ Conversational Analytics
    • HeavyIQ Overview
      • HeavyIQ Guidance
  • HeavyRF
    • Introduction to HeavyRF
    • Getting Started
    • HeavyRF Table Functions
  • HeavyConnect
    • HeavyConnect Release Overview
    • Getting Started
    • Best Practices
    • Examples
    • Command Reference
    • Parquet Data Wrapper Reference
    • ODBC Data Wrapper Reference
    • Raster Data Wrapper Reference
  • HeavyML (BETA)
    • HeavyML Overview
    • Clustering Algorithms
    • Regression Algorithms
      • Linear Regression
      • Random Forest Regression
      • Decision Tree Regression
      • Gradient Boosting Tree Regression
    • Principal Components Analysis
  • Python / Data Science
    • Data Science Foundation
    • JupyterLab Installation and Configuration
    • Using HEAVY.AI with JupyterLab
    • Python User-Defined Functions (UDFs) with the Remote Backend Compiler (RBC)
      • Installation
      • Registering and Using a Function
      • User-Defined Table Functions
      • RBC UDF/UDTF Example Notebooks
      • General UDF/UDTF Tutorial Notebooks
      • RBC API Reference
    • Ibis
    • Interactive Data Exploration with Altair
    • Additional Examples
      • Forecasting with HEAVY.AI and Prophet
  • APIs and Interfaces
    • Overview
    • heavysql
    • Thrift
    • JDBC
    • ODBC
    • Vega
      • Vega Tutorials
        • Vega at a Glance
        • Getting Started with Vega
        • Getting More from Your Data
        • Creating More Advanced Charts
        • Using Polys Marks Type
        • Vega Accumulator
        • Using Transform Aggregation
        • Improving Rendering with SQL Extensions
      • Vega Reference Overview
        • data Property
        • projections Property
        • scales Property
        • marks Property
      • Migration
        • Migrating Vega Code to Dynamic Poly Rendering
      • Try Vega
    • RJDBC
    • SQuirreL SQL
    • heavyai-connector
  • Tutorials and Demos
    • Loading Data
    • Using Heavy Immerse
    • Hello World
    • Creating a Kafka Streaming Application
    • Getting Started with Open Source
    • Try Vega
  • Troubleshooting and Special Topics
    • FAQs
    • Troubleshooting
    • Vulkan Renderer
    • Optimizing
    • Known Issues and Limitations
    • Logs and Monitoring
    • Archived Release Notes
      • Release 6.x
      • Release 5.x
      • Release 4.x
      • Release 3.x
Powered by GitBook
On this page
  • Chart Style
  • Sort By
  • # of Groups
  • Null Dimensions
  • Color Palette
  • Labels
  • Custom Measure Formatting
  • "All Others" Value
  • Pie Chart Examples
Export as PDF
  1. HeavyImmerse
  2. Chart Types

Pie

PreviousNumberNextPointmap

Last updated 8 months ago

To learn more about pie charts and how to create one, please view this

The Pie chart lets you compare the relative sizes of groups of data as segments of a circle.

Features

Quantity

Notes

1+

Minimum 1, no limit, null dimensions optional.

1-2

Measure 1 = segment size, Measure 2 = segment color.

Use a Pie chart to show the relative proportions of a small number categories. If you have many categories, or the values are very similar in size, a Bar chart is often a more effective way to compare the categories. Note also that you should not create Pie charts with a mix of positive and negative values.

Chart Style

You can style your chart as a Donut or a Pie, depending on your dessert preference. The default Donut style tends to make it easier to see the relative sizes of the chart divisions.

Sort By

SORT BY determines the order of the sections starting at the 12 o'clock position and proceeding around the chart in clockwise fashion.

# of Groups

You can divide your chart into up to 100 values. A smaller number of values often results in a more readable chart.

Null Dimensions

You have the option of hiding null dimensions if they are not significant in your data sample.

Color Palette

You can choose 1, 2, 3, 4, or 9 colors for your chart. You can also use a gradient color to show relative values within a dimension.

Labels

You can toggle off or on the absolute value labels on the pie sections. This toggle is always enabled and available.

When the measure values for your chart represent the number of records or a sum aggregate value, you can show percentage labels of each slice relative to the other slices of the pie. This value always appears in the popup when you hover over a slice (when the feature is available). In the chart editor, you can toggle the percentages on or off (default) for each slice.

If you create the chart using Number of Records or the Sum size measure, then change to a different kind of value, the Percentage and "All Others" settings toggles turn off, with a ToolTip explanation when you hover over them.

Custom Measure Formatting

"All Others" Value

When you select "All Others," you add an extra section to the pie representing all dimension groups that are not already represented by a slice. The section is grey and cannot be selected to crossfilter. Otherwise, it acts like any other slice. You can toggle the All Others value on (default) or off in the chart editor.

Pie Chart Examples

Use the Dimension state_name and the Size measure AVG Employment.

You can use the Color measure to reflect the Unemployment_rate, providing more nuanced understanding of the relative segments.

There are 50 states, so it might be tempting to show all 50 in the chart. The problem becomes obvious when there are too many segments with too little variation to provide meaningful analysis. 10 or fewer is probably a reasonable setting for # of Groups.

Changing the Color Palette might make an outlier such as Michigan stand out more effectively.

Where the segments do not have sufficient width to display the measures, you can mouse over to see a pop-up with the information for your chosen segment.

Required

Required

You can also use custom measure formats for the value in your chart. See .

Create a new Pie chart. Choose a Data Source. This example graphs employment statistics for all 50 United States for the year 1980. The data is available at the .

video.
University of Kentucky website
Customizing Measure and Date Formats
Dimensions
Measures