Donut chart

To describe a donut chart, use the DonutChart configuration:

• name - your chart's name. Must be unique within the workbook.

• dataset - the ID of the dataset whose data to visualize.

• ad_hoc_fields - (optional) describe the calculated fields to use in the chart.

• visualization - describe the configuration of your chart:

  • kind: donut_chart - specify the chart type.

  • measures - configure the data reference for the chart:

    • source - specify the data source:

      • kind: ref - take the data from the reference data source. This is the dataset specified above.

      • id - specify the ID of the data field from the dataset whose data will be visualized.

  • sort - specify the data field to be used as a sorting reference:

    • source - specify the data source:

      • kind: ref - take the data from the reference data source. This is the dataset specified above.

      • id - specify the ID of the data field from the dataset whose data to use as sorting reference.

    • direction - configure the sorting direction to apply to the chart. You can assign ASC for ascending or DESC for descending.

  • coloring (optional)

    • kind - specify which data type field to use as a color filter. You can specify a dimension or measure.

    • source - specify the data source:

      • kind: ref - take the data from the reference data source. This is the dataset specified above.

      • id - specify the ID of the data field from the dataset whose data will be used as a color filter.

    • palette_id - select the palette to apply to the chart. For most cases, use default-palette.

    • mounts - assign colors from the palette to data points from the source:

      • value - specify the exact value from the source.

      • color_idx - match the above value to a color swatch number in the palette.

- name: ch_columns_sales_per_region
chart:
   datasets:
   - ds_sales
   ad_hoc_fields: []
   visualization:
      kind: column_chart
      x:
      source:
         kind: ref
         id: order_month
      y:
      - source:
         kind: ref
         id: sum_sales
      sort: []
      coloring: null

To open data type settings, click the field type icon before the field name:

• for Integer type fields:

  Name	Description	Possible values
  Name	Sets the name of the measure	A string of characters.
  Type (Before aggregation)	Sets the field's data type.	Integer, Fractional number, String, Logical, Date, Date and time
  Aggregation	Applies a selected aggregation function to the data field.	No: doesn't apply aggregation. Count: applies the COUNT function, returns the total number of entries. Sum: applies the SUM function, returns the sum of all the field's values. Average: applies the AVG function, returns the arithmetic mean value. Minimum: applies the MIN function, returns the minimum value. Maximum: applies the MAX function, returns the maximum value. Count distinct: applies the COUNTD function to the data field and returns the number of unique values in the field.
  Label	Displays labels with values on the chart.	Show, Hide
  Precision	Sets the number of characters displayed after the decimal point in a value.	Any positive integer.
  Format	Sets the value display format	Number: display the values as plain numbers. Percent: show the values as a percentage.
  Show delimiter	Toggles the separation of groups of thousands.	Show: display spaces between groups of thousands. Hide: hide spaces between groups of thousands.
  Prefix	Sets a text to display before the value	A string of characters.
  Postfix	Sets a text to display after the value.	A string of characters.
  Units	Sets a rounding scale to apply to the field's values.	Null: don't apply rounding. Auto: select and apply a rounding scale automatically. Thousands, K: round to thousands, display 000 as K. Millions, M: round to millions, display 000 000 as M. Billions, B: round to billions, display 000 000 000 as B. Trillions, T: round to trillions, display 000 000 000 000 as T.

• for String type fields:

  Name	Description	Possible values
  Name	Sets the name of the dimension	A string of characters.
  Type	Sets the field's data type.	Integer, Fractional number, String, Logical, Date, Date and time
  Aggregation	Sets the aggregation type	No: doesn't apply aggregation. Count: applies the COUNT function to the data field and shows the number total number of entries. Count distinct: applies the COUNTD function to the data field and returns the number of unique values in the field.

• Date type fields will convert into Integer.

• Geodata type fields aren't supported by this chart type.

To open chart settings, click to the right of the chart type above the wizard slot fields. You'll see a dialog window with the following controls:

After managing the controls, click Apply to see the results on the chart preview.

To open slot settings, click in a row with the slot name.

Color:

On the left, you can select a line from a data source in the Colors slot of your chart.

On the right, you can select a color scheme and a color for the line. Select AUTO to let Visualization do the coloring for you.

• This chart type can't display NULL or negative values.

• We recommend displaying no more than three to six measures in a chart.

• To display the values for each data point, drag Measure values to the Signatures section.