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 Modifiedto open the Condition Builder , establish your conditions, then click - .
- Set the filters.
- Click Refresh to apply changes.
Image Removed 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. Info |
---|
The Aggregation Column is only available if the Aggregation Type option is Average, Count Distinct, Sum. |
|
Groups |
limitIn this field, set Limit | N | 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
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 Removed
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. Info |
---|
This field appears when the Aggregation Type field in the Configure tab contains Sum or Average. |
|
Title |
---|
Style |
---|
Field | Mandatory | Description |
---|
Report Title Show Type | N | Select |
Report title show type | 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. |
Drilldown data
Image Removed