Charts are useful when you want to display your data on a bar or line chart and demonstrate important relationships between the data points.
After adding the chart into an table or dashboard as explained in the previous chapter, you have to setup these following steps:
1) Data from table - After adding a label to the table, you have to select whether you want data from a table or from a customer source created in the Data source extension to appear in the chart.
2) Chart type - whether the chart will consist of bar or line.
3) X-axis - In this step you have to select the right fields from the table that will be afterwards shown in the chart. Moreover, you can select whether the data will have ascending or descending tendency.
4) Y-axis - You can choose whether the data will be displayed as a count or if they will be grouped by any other field of the table and also if those values will be ascending or descending.
5) Filters - Filters are useful If you want just some specific folders from fields to display in the chart. In case you want to link them with already setup user filters within the scheme, click on the option - Link with user filters.
6) Formatting - Here you can add unit prefix or suffix to X-axis or Y-axis. You can set up maximum fields to be displayed in the chart and what is more, you can as well set up how many items will appear when the graph will be opened in fullscreen.
7) Widget appearance - You can select the most suitable colour for the background of the chart, then set up if the legend will be shown if the data values will appear above each bar and lastly if the chart will stay vertical or will be switched to horizontal.
2) Pie chart
This type of chart helps you to visualize your records on a pie or doughnut chart.
In the comparison with the previous chart, there are only two differences in the settings and that is:
1) Chart type: whether the chart will take a shape of pie or doughnut.
2) Group by field - You choose the correct field from which you want the data to be displayed in the chart.
An example of a pie chart on the left and doughnut chart on the right in Tabidoo
The rest of the settings are the same as ones of the previous widget.