LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page
  • Heatmap
  • Thresholds
  • Total Labels
  • Background Image

Was this helpful?

  1. CHARTS USER GUIDE

Table heatmap

PreviousGrid ChartNextHistogram Chart

Last updated 7 days ago

Was this helpful?

A heatmap is a graphical representation of data that shows a metric at the intersection of two attribute values. The custom table heatmap in VitaraCharts allows you to insert numerous attributes on the columns (axis and y-axis) and illustrate the differences in the measures at a glance. Below is an example table heatmap.

Inputs

Metrics: The minimum 1 metric is required.

Attributes: A minimum of 2 attributes are required. The first attribute A1 is used for the x-axis and the second attribute A2 is used for the Y axis.

Use as Filter Option - Available

Thresholds Option - Available

Heatmap

From the 4.5 version of Vitara charts, the cell border properties are added to the heatmap chart. Border width, Border radius and Border color are the three options added in the cell border properties.

The “border radius” feature in a heatmap chart allows users to adjust the curvature of cell corners within the heatmap grid. This feature enhances visual aesthetics by providing control over the roundness of cell edges, improving the overall appearance and customization options in heatmap-based data visualizations.

The “border width” feature in a heatmap chart lets users adjust the thickness of the lines separating cells. It aids in enhancing readability, highlighting cell boundaries, and providing customization options to optimize the heatmap’s appearance, making data visualization and analysis more effective.

The “border color” feature in a heatmap chart enables users to customize the color of the lines or borders that separate individual cells or squares in the heatmap grid. This feature enhances visual distinction and allows for further customization of the heatmap’s appearance, aiding data interpretation and analysis.

Below is the example where the applied border properties are shown Border width - 3 Border radius - 15 Border color - Sky blue

Thresholds

In the business point of view, certain part of the chart needs to be highlighted to draw more attention from the desicion makers. For example, highlight the stores where total sales is greater than a specific value or highlight the top 10 products whose sales is high during last year’s winter. Thresholds are very useful objects in these use cases.

Thresholds will display some conditional formatting in a chart to highlight certain data points depending on predefined criteria.The criteria are attribute or metric qualifications. If a qualification’s expression evaluates to TRUE, the report displays the threshold. We can also include markers in thresholds.

To apply thresholds in vitara charts, hover the cursor on the chart. Vitara chart will display an ‘Edit’ button. When you click on this ‘Edit’ button the properties window will pop out. Select the thresholds tab to open threshold editor. In the window you can add a new threshold or delete any existing threshold or modify the existing threshold.

Note: As of version 4.6, we can use characteristics to impose thresholds. All the measurements and attributes in the chart are listed in the source drop-down box in the threshold editing window. We can choose a source attribute and specify a threshold condition.

By default, Heatmap establishes a threshold (Gradient threshold) and bases the plot colours on it. The heatmap’s threshold editor is seen in the screenshot below. The chart’s default threshold is displayed by the threshold editor. By selecting the ‘Add’ option, we can modify this threshold, delete it, and add a new one.

Total Labels

As of Vitara charts version 4.9.2, the heatmap chart by default shows vertical and horizontal totals.The data labels menu has an option for this feature. The data labels menu’s ‘Total Labels’ option can be enabled or disabled independently of the ‘All’ selection for the heatmap chart.

Background Image

The steps to set a background image for all Vitara charts are explained in .

backgroundImage