Documentation

    Calendar heatmap

    Calendar heatmap lays out the days of the year as a grid of cells and colors each one by a value calculated from that day's rows.

    See daily orders across a year

    Eight weeks of orders from February and March 2026 fill the calendar. Every weekend is empty at zero, and every Friday is darkest, with 8 to 10 orders.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    DateOrders
    2026-02-022
    2026-02-034
    2026-02-043
    2026-02-055
    2026-02-068
    2026-02-070
    2026-02-080
    2026-02-093
    1. In the Data tab, change Operation from Sum to Count rows. The cells now show how many rows each day has.
    2. Open the Design tab and expand Calendar labels and layout to change the day and month names.
    3. Change Empty cell color to see which days have no rows.

    When to use

    Use Calendar heatmap to show weekly and seasonal patterns, because each day keeps its place in the week. For an overall trend, use Line, but it turns a weekly pattern like this one into a repeating zigzag.

    Inputs

    1 port
    Table

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    A calendar shows up to 10,000 cells.

    Calendar date

    Date column for the task start, event date or calendar day. Auto picks one.

    Cell value

    Column calculated for each calendar day. Auto picks one with varied values.

    Operation

    How the value column is calculated for each category. Columns that aren't numeric are counted. Called Operation on Calendar heatmap.

    Default: Sum

    Options: Sum, Average, Median, Minimum, Maximum, 25th percentile, 75th percentile, 90th percentile, 95th percentile, Percentile, First by time, Last by time, Count values, Count distinct, Count rows, Count true, Percentage true.

    27 more settings
    Show tooltip

    Shows or hides values when you hover over a mark.

    Default: true

    Tooltip

    Text shown when you hover over a mark. Write it in the editor and insert values from Values.

    Values

    Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.

    Title

    Title shown inside the chart. Leave empty to hide it.

    Title color

    Color of the title.

    Title size

    Size of the title, in pixels.

    Default: 24

    Title alignment (plot)

    Alignment of the title.

    Default: Left

    Options: Left, Center, Right.

    Empty cell color

    Color of days without data. Auto uses the plot background.

    Day names

    Short (Mon) or full (Monday) weekday names.

    Default: Short

    Options: Short, Full.

    Month names

    Short (Jan) or full (January) month names.

    Default: Short

    Options: Short, Full.

    Year gap

    Space between years, in pixels.

    Default: 24

    Day label size

    Size of the weekday labels, in pixels.

    Default: 9

    Day label color

    Color of the weekday labels.

    Month label size

    Size of the month names, in pixels.

    Default: 9

    Month label color

    Color of the month names.

    Year label size

    Size of the year labels, in pixels.

    Default: 12

    Year label color

    Color of the year labels.

    Background

    Card background color. Auto follows the theme.

    Plot padding

    Space between the card edge and the chart, in pixels.

    Default: 0

    Scale

    Unit for cell values and tooltips.

    Default: None

    Options: None, Thousands (K), Millions (M), Billions (B).

    Prefix

    Text before each value.

    Suffix

    Text after each value.

    Decimal places

    Most decimal places shown on value-axis labels and in tooltips.

    Default: 2

    Always show decimal places

    Pads values to the decimal places, so with 2, 2630 shows as 2,630.00.

    Default: false

    Thousands separators

    Groups digits, so 2630 shows as 2,630.

    Default: true

    Corner radius (px)

    Corner radius in whole logical pixels.

    Default: 0

    Border width (px)

    Border width in whole logical pixels.

    Default: 0

    Calendar heatmap FAQs

    Why does a calendar heatmap ignore larger date groups?
    It always draws one cell per day. Timestamps follow the chart time zone, and dates keep their calendar date.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.