Pie Chart

Pie Chart

A Pie Chart is a special chart that uses pie slices to show relative sizes of data. It shows how a total amount is divided between levels of a categorical variable as a circle divided into radial slices.

How to Create a Pie Chart:

  • First, you need to go to Visualization Section in Reports V2 and select the Pie Chart option.

  • Now in the Build panel go to the Values part inside Chart Setting section and Choose or Drop the relevant Measure columns with desired aggregation functions such as Sum of Sales, Count of Orders, etc wrt which you want to plot the Pie Chart.

  • Now in the Labels section, you need to select the relevant Dimension Column(preferably a Categorical column) using which you want to divide the selected Data into different slices in the Pie Chart.

  • Then Click on the Run Button and your Pie Chart will be ready.

For eg: You want to create a Sales per Product Category report using a Pie Chart. It can be done easily using Report V2's Pie Chart option. You will first need to select the Measure column "Sales" in the Value part of Chart Settings and select the "Product Category" column in the Labels part of the same. Then you will need to click on the Run button and your desired Pie Chart report will be ready.

In Report V2 Pie Chart has two panels Build and Format.

Build

his panel is like a building block for the Pie Chart. It allows you to select various Dimension and Measure columns for creating the Pie Chart.

It is further divided into 3 parts:

Chart Settings: This allows you to select the relevant Dimension and Measure Columns.

  • Values: Here you can select 1 Measure Column using which you need to plot the Pie Chart.

  • Labels: Here you can select 1 Dimension Column using which you need to create the different slices in the Pie Chart.

Row Limit: This allows you to limit the Output rows by going to the Row Limit section in the Build panel then selecting the number of rows and clicking on the Run Button.

Sort: This allows you to Sort the report based on certain columns. Go to the Sort option at the bottom in the Build panel then choose one or more columns along with the order Ascending or Descending and then click on the Run button.

Format

This panel allows you to apply various formatting techniques on the Pie Chart to make it more customized as per your need.

It consists of various different sections which are as follows:

Title: This allows you to give a Title to the Pie Chart. You just need to go to the Title section in the Format panel, enter the title and click Apply button.

Option: This allows you to decide and control the geometric aspects of the Pie Chart like its radius, border width, etc. It has 4 components:

  • Radius: It allows you to set the radius for the inner circle of the Pie Chart. It helps in creating a Donut Chart by increasing the inner Radius value.

  • Border Width: It allows you to set the width of each slice's border in the Pie Chart.

  • Border Radius: It allows you to set the border radius for each slice in the Pie Chart.

  • Rose:

Data Labels: It allows you to enable/disable the visibility of data labels in the Pie Chart. By default, it will be disabled. It has the following components:

  • Font Size: This allows you to choose the font size of the date labels to be shown in the Pie Chart as per your need.

  • Font Weight: This allows you to decide the appearance of the date labels in the Pie Chart. You can choose either Normal or Bold.

  • Font Style: This allows you to choose the font style of the data labels in the Pie Chart. You can choose either Normal or Italic.

  • Font Family: This allows you to choose the font family of the data labels in the Pie Chart. You can choose from a set of different Font Family as per your need.

Legend: This allows you an option whether you want to showcase the chart legends in your Pie Chart or not with the help of a toggle button. By default it is disabled but you easily enable it by clicking on the Show Legend toggle button.

How to enable and show Legend in your Pie Chart:

  • First, you need to go to the Legend section in the Format panel and enable the Show Legend toggle button.

  • A new dropdown will open up.

  • You then need to select the Legend Type: Plain or Scroll. (Plain when you have less number of legends like 2-4 and Scroll when you have a large number of legends like more than 4).

  • Font Size: This allows you to choose the font size of the Legends to be shown in the Pie Chart as per your need.

  • Font Weight: This allows you to decide the appearance of Legend's font in the Pie Chart. You can choose either Normal or Bold.

  • Font Style: This allows you to choose the font style for Legends' font in the Pie Chart. You can choose either Normal or Italic.

  • Font Family: This allows you to choose the font family for Legends' font in the Pie Chart. You can choose from a set of different Font Family as per your need.

  • Icon: This allows you to choose the icon appearing alongside the Legends in the Pie Chart. You can choose from a set of different Icon types like Circles, Triangles, etc as per your need. Then Click on the Apply button to reflect the changes.

Grid Offset: It allows you to adjust the chart grid as per your need. It has 4 offset types: Right, Left, Top, and Bottom.

Filed Formatting: This allows you to format field values in the selected dimension and measure columns as per your requirement. It involves changing the field values like the field value's display units, number of decimal places, adding any prefix or suffix, etc.

Last updated