Charts add eye-catching graphics to your projects to help users visualize their data and see it from a different perspective. You can even present multiple charts side-by-side using a Container Component.
In the Layout Editor, select the tab you want to add the chart to.
Click on the plus (+) symbol in the Components panel.
Select the desired chart style (Bar Chart, Line Chart, or Radial Chart).
Select a Data Source for your chart in the configuration panel on the right of the Layout Editor. This can be a table from your project's data source or a Relation. You can also give your chart a Title to make it clear what data is being displayed.
If you've selected a Bar or Line chart, you'll see a Style section that allows you to change the chart type and switch between the two.
Select a column to use as the Label (if a radial chart) or X-Axis (if a linear chart). This determines what values the data is grouped by. This will appear at the bottom of the chart and in floating hints when users hover over the chart.
Select a column to use as the Value. This determines the bar height or line direction. You can also name the graphs using the Caption field.
Click the Add item button to display additional values from the chart's data source.
Depending on the style you've chosen, you can customize what is displayed on the chart (i.e. Show x labels, Show y labels, Show grid lines, Show legend, etc.).
For each chart style, you can also Limit number of items displayed or adjust the Page size.
You can customize the data displayed in your chart by using Conditions and other options.
You can define when your chart will be displayed by creating specific conditions to be met. In the Visibility section, click the Add Condition button to create your conditions.
You can limit the items displayed in your chart. In the Filter Data section, click the Add Filter button to create your filters.
By default, chart data will appear in the same order as they appear in its data source. However, if you are using a Bar chart, you can customize the legend's sort. In the Sort section, click on the Sort by Sheet order field to expand the options and configure it.
You can enable the Show search bar option so users can search the chart items more quickly. You can also configure the In-App Filter property to allow users to find specific data in the chart.
Suppose you have a table which shows orders for a shop. You've added a radial chart and selected Orders as the Label. You've left the Values blank.
Apple Pie Muffin
Lana Del Ray
Apple Pie Muffin
If the Label property is the only option configured, the chart will display the total number of orders placed, grouped by the values in the Orders column.
If you select the Count column as the Values property, then the chart changes significantly. Now the chart shows how many of that particular item were ordered.