Gain insights into your data and take appropriate action by creating a page with a chart that shows data from your model's properties.
Choose the type of chart you want to add, such as an area chart, a bar chart, a line chart, or a pie chart. Then configure your chart by choosing the data that you want to show. You can choose your data source, and add filters and conditions.
Also, add other properties from related models to your chart. Customize how you want your chart to look by adding a subtitle, and a legend and customizing how you want your x-axis and y-axis labels to look.
Aggregating data in charts
You can show each data from each property in a model or you can show aggregated values of a property. For example, you might want to see the total count of employees in a job role or department.
Count
For the selected property, this counts the number of values with the same value. For example, if you have a model called Users with a Job property, you would select Count and then Job. A pie chart shows the segment with the property value as the label, and if you place your mouse cursor over the segment, you can see the count of values with the same value.
- A number property name - sum: For the selected property with the same values, this adds all the number property values.
This shows in the Properties list as your number property name with - sum attached to it. For example, if you selected Job and Salary - sum, you would see the total of all salaries for each Job.
- A number property name - minimum: For the selected property with the same values, this shows only the number property's lowest value.
This shows in the Properties list as your number property name with - minimum attached to it. For example, if you selected Job and Salary - minimum, you would only see the lowest value for each job's salary property.
- A number property name - maximum: For the selected property with the same values, this shows only the number property's highest value.
This shows in the Properties list as your number property name with - maximum attached to it. For example, if you selected Job and Salary - maximum, you would only see the highest value for each job's Salary property.
- A number property name - average: For the selected property with the same values, this shows the number property's average value.
This shows in the Properties list as your number property name with - average attached to it. For example, if you selected Job and Salary - average, you would only see the calculated average for the Salary property for each Job.