Documentation

    Pie chart

    Pie chart shows how a total splits into parts, one slice per category. Choose a category and a value, and each slice takes its share of the circle.

    Split cups sold by drink

    Coffee takes half of the 60 cups sold, tea a third and cocoa a sixth, with one slice per drink.

    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
    DrinkCups
    Tea20
    Coffee30
    Cocoa10
    1. Open the dropdown at the top of Properties. It shows Pie chart. Choose Treemap. The same shares now draw as tiles.
    2. Go back to Pie chart, open the Design tab and expand Shape and layout to change how the slices are drawn.
    3. In the Data tab, change Sort by to order the parts by value.

    When to use

    Use Pie chart to show what share each part holds when there are only a few parts, such as three drinks. Slices get hard to compare as they multiply, so use Treemap for many parts.

    Inputs

    1 port
    Table

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    Only positive values take up area, so filter out or recalculate negative values.

    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.

    29 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.

    Shape

    Full circle or half circle.

    Default: Full

    Options: Full, Half.

    Fill

    Solid pie or donut with a hole.

    Default: Donut

    Options: Solid, Donut.

    Hole size

    Donut hole radius as % of the pie (0–95).

    Default: 40

    Slice gap

    Space between slices, in pixels.

    Default: 0

    Labels

    What each slice label shows. With a breakdown, labels show the category names. Without one, the measure's number format applies.

    Default: Split

    Options: None, Split, Measure, Split + measure.

    Label position

    Labels outside with callout lines, or inside the slices.

    Default: Outside

    Options: Outside, Inside.

    Label size

    Size of the slice labels, in pixels.

    Default: 12

    Label color

    Color of the slice labels.

    Center text

    Text inside the donut hole.

    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

    Pie chart FAQs

    What happens to negative values in a pie chart?
    They can't occupy area. Use another operation or filter the rows in Strata. Groups that are zero still appear in tooltips.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.