Documentation

    Waffle chart

    Waffle chart fills a grid of tiles in proportion to each category, so a share can be read almost by counting. Tiles approximate each share.

    Show survey answers as tiles

    A 10 by 10 grid holds a survey of 100 people: 70 tiles for Yes and 30 for No, so each tile happens to be one person.

    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
    AnswerPeople
    true70
    false30
    1. Open the Design tab and expand Shape and layout to change the number of rows and columns.
    2. In the Data tab, change Sort by to change the order in which the tiles fill.
    3. Open the dropdown at the top of Properties. It shows Waffle chart. Choose Pie chart to compare the same shares as slices.

    When to use

    Use Waffle chart to show a share in a way most readers can take in at once, almost by counting tiles. Tiles only approximate most shares, so use Pie chart with labels or a table when the exact percentage matters.

    Inputs

    1 port
    Table

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    Group by

    Column for the parts. Auto picks a readable one.

    Group dates by

    How dates in this field are grouped, such as by day, month or year.

    Default: Day

    Options: Exact, Second, Minute, Hour, Day, Week, Month, Quarter, Year, Month of year, Day of week, Hour of day.

    Grouping

    Groups each number on its own, or into equal-width ranges.

    Default: Individual values

    Options: Individual values, Fixed-width ranges.

    Part value

    Column calculated into the size of each part. Auto picks one with varied values.

    Operation

    How the value column is calculated for each category. Columns that aren't numeric are counted.

    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.

    Sort by

    Sorts parts by their value.

    Default: Default

    Options: Default, Ascending, Descending, Group ascending, Group descending.

    24 more settings
    Period size

    Number of units in each period. Hours, minutes and seconds count fixed intervals from 1970-01-01 in the chart's time zone. Calendar periods follow local boundaries.

    Default: 1

    Source timezone

    IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.

    Default: UTC

    Chart timezone

    IANA time zone used for grouping and display. Vista filters keep their own time zone.

    Default: UTC

    Week starts

    Day the week starts on.

    Default: Monday

    Options: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

    Fiscal year starts

    Month the fiscal year starts in. Sets quarter and year boundaries.

    Default: January

    Options: January, February, March, April, May, June, July, August, September, October, November, December.

    showTooltip

    Shows or hides values when you hover over a mark.

    Default: true

    Tooltip

    Use the automatic summary, or write your own text with values.

    Default: Automatic

    Options: Automatic, Custom.

    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.

    Date labels

    How dates are written in the chart labels.

    Default: Auto

    Options: Auto, Iso, Date, Datetime, Custom.

    Tooltip dates

    How dates are written in tooltips.

    Default: Iso

    Options: Auto, Iso, Date, Datetime, Custom.

    Tooltip decimal places

    -1 uses the measure's format.

    Default: -1

    Thousands separators

    Groups digits with thousands separators in tooltip numbers.

    Default: true

    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.

    Grid

    Standard 10×10 grid or custom dimensions.

    Default: Standard 10×10

    Options: Standard 10×10, Custom.

    Fill sweep

    Fills cells row by row or column by column.

    Default: Rows

    Options: Rows, Columns.

    Reverse fill

    Fills from the opposite edge. Tiles show each category's share roughly, and Reverse changes the direction within each row or column.

    Default: false

    Tile gap

    Space between cells, in pixels.

    Default: 1

    Background

    Card background color. Auto follows the theme.

    Plot padding

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

    Default: 0

    Corner radius (px)

    Corner radius in whole logical pixels.

    Default: 0

    Border width (px)

    Border width in whole logical pixels.

    Default: 0

    Waffle chart FAQs

    Why doesn't the waffle chart match the exact percentages?
    Tiles come in whole numbers, so each group's tile count approximates its share. A 10 by 10 grid makes one tile about 1%.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.