Pie reports Reports display data in a circular graphic divided into slices. The whole graph represents the entire report data along with each slice proportionally displaying a particular data category. It is the easiest way to clearly show the proportion of each quantity as a
Tip |
---|
This report view is useful to compare the proportions of individual values to the whole. |
Info |
---|
The pie chart is the most obvious when the number of sections is small. |
Image Removed
Image Added
Create a pie report
Use Report Designer to create, configure, and style customize pie reports.
Panel |
---|
title | To create a Pie Report, follow the steps below: |
---|
|
- Navigate to the Reports → Create a ReportNew.
- On the the Data tab tab, fill in the mandatory fields:
- Report name - Name – enter the desired name;.
- Table – select Table - select the table you want to use as a the source.
- Click Next or the Type tab to continue.
- On the the Type tab, select Pie report option and click Next.
- Configure a report, and click Refresh to build a report.
- tab, click the Pie icon:
Image Added - Click Next or the Configure tab.
Fill in the mandatory field and configure the data, then click Refresh to generate a report. Note |
---|
The Report Designer can stop the report generating if there is a large amount of data to display. Use the Condition Builder to limit the data sampling or try another type of report. |
- Customize the Customize a style of the report created, and click Refresh.
- Click Click Save.
Info |
---|
To open the saved report, navigate to the to Reports → All reports menu and Reports and select one from the list. |
|
Configure a pie chart | configure the data pie report |
---|
| configure the data pie report |
---|
|
Configure the data
On the Configure tab, use settings to specify the source datasets to build the desired report.
To configure a report, follow the steps below:
- On the Configure tab, specify fill in the report datasetfields.
- Click Refresh to build the report.
- Click Save to save the report.
Info |
---|
Use the the Condition Builder to to establish additional conditions for your report data filtering and grouping: - Click the icon
Image Addedto open the Condition Builder. - Set the filters.
- Click Refresh to apply changes.
Image Added
|
Anchor |
---|
| configure tab fields pie report |
---|
| configure tab fields pie report |
---|
|
Field | Mandatory | Description |
---|
Group by | Y | Select a table column as a |
criteria criterion for data grouping. |
Add |
data tableData Table | N | Set this checkbox on to show the data table below your report view. |
Aggregation |
typeThe data aggregation allows preparing the Type | N | Select the data aggregation to create combined datasets for data processing |
according to the user needs.Select a type of the numeric data aggregation with one of these - counts - – counts an average number of the column values.
|
It makes sense if the aggregation column keeps the numeric data.Count - counts -
- Count – counts a number of
|
the column values distinct - counts - Distinct – counts the number of unique values of the column
|
set in the Aggregation column.Sum - .Aggregation column- .
- Sum – counts the sum of the numeric data values in this table column.
Info |
---|
The Sum and Average settings make sense if the aggregation column keeps the numeric data. |
The aggregation option selected is applied to the table column set in the Aggregation Column field. |
Aggregation Column | N | Select a table column with numeric values for data aggregation. |
Groups limit | The Aggregation Column is only available if the Aggregation Type option is Average, Count Distinct, Sum. |
|
Groups Limit | N | Set |
In this field, set the limit of the data groups shown in your report |
with a particular number rest otherSet on to show the data groups not included in Groups |
limitCustomize a style
Info |
---|
The Show Rest as Other is only available if the Groups Limit option is specified. |
|
Anchor |
---|
| customize the style pie report |
---|
| customize the style pie report |
---|
|
Customize the style
On the Style tab, you You can configure the report look in any way you want with the style settings.
To customize a report style, follow the steps below:
- On the Style tab of your report, configure the settings.
- Click Refresh to apply the changes.
- Click Save to save the report.
Image Added
Change colors, add titles, and customize the data list and table views with the settings below.
The Style tab fields
Style |
---|
Field | Mandatory | Description |
---|
Chart |
color typeColor Type | N | Select the color type of your pie chart from one of these options: |
;; |
Color | N | Set the color for your pie chart if you selected |
as the color type. Click the magnifier icon Image Added to select one of the available colors. |
Palette | N | |
pallete palette for your pie chart if you selected |
pallete palette as the color type. |
Display data tables | Click the magnifier icon Image Added to select one of the available palettes. |
Display Data Lables | N | Select this checkbox |
Switch this checkbox on to display the data labels on your pie chart. |
Drilldown |
list layoutSelect the list layout that specifies the look of the data list drilldowned. | List Layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon Image Added to select a list view of the source table.
|
Decimal Precision | N | |
Report height | Set the number defining how much numbers should be displayed after the point of numeric data values in your chart. |
Title Style |
---|
Report title show type | Info |
---|
This field appears when the Aggregation Type field in the Configure tab contains Sum or Average. |
|
Title |
---|
Field | Mandatory | Description |
---|
Report Title Show Type | N | Select |
Set the type for the report title showing. |
Select one of the ; only; titleEnter Specify the title of the report |
you create title sizeEnter Title Size | N | Specify the number of |
points pixels to set the size of the report title. |
Report |
title colorTitle Color | N | Select the color of the report title. Click the magnifier icon Image Added to select one of the available colors. |
Title |
horizontal alignmentSet the horizontal chart title with one of the report title. Available options: |
;Center;.Title vertical alignment | Set the vertical alignment of the chart title with one of the options:
Top;Middle;- Top
- Right Bottom
- Center Top
- Center Bottom.
|
Bold Title |
boldSwitch on chart Style |
---|
Field | Mandatory | Description |
---|
Show |
legendSet on to make the chart legend show. |
Legend |
horizontal alignment horizontal alignment of the chart legend |
with one of the ;Center;.- Top
- Right Bottom
- Center Top
- Center
|
Legend vertical alignment | Set the vertical alignment of the chart legend with one of the options:
Top;Middle; legend borderSet on to make display the border of your chart legend show. |