Charts

to add a chart please click on the 'add widget' button (see screenshot below), then on 'chart' you can delete the chart by clicking on the 'delete icon' (see screenshot below) chart settings titles here you can name the chart in all languages that are available on your tenant target here you can choose a cms entity that will be used to form a chart (for example contacts, vehicles, organizations, etc ) and a type of chart chart types pie and donut those charts use pie slices to show relative sizes of data bar chart presents categorical data with rectangular bars with heights proportional to the values that they represent step, area step, line, spline, area spline area all are variants of the chart that tracks the changes of the certain value(s) over time funnel chart specialized chart type that typically demonstrates the flow of users through a business or sales process for example, it can be used to show how many users opened your email, then clicked the link, etc metric chart this chart is most of the time used to display a single number (average price of the car, number of orders, etc ) the settings and functions of this chart are the same as in the clickable metrics in cms (except the metrics in the hyperbi can`t be clickable) metrics metrics determine the type of calculation that will be done to the values of the chosen entity they are responsible for the display of the values on the y axis count values this metric will count all items, for example it will show the number of cars that were sold on a certain day count unique values this metric is the same as 'count values' but it only includes unique values, you can also select the property that will be counted for example it will only count one red car if there are six of them this metric is also available in all charts sum this metric sums all numerical values only 'number type' properties can be selected for this metric for example you can create a chart that shows your daily revenue (the sum of the prices of the cars that were sold each day) this metric is not available in pie charts average this metric shows an average numeric value only 'number type' properties can be selected for this metric for example you can create a chart that shows an average price of a car that was sold on a certain day this metric is not available in pie charts max this metric shows the highest numeric value only 'number type' properties can be selected for this metric for example the chart will show the price of the most expensive car that was sold on a certain day this metric is not available in pie charts min this metric shows the lovest numeric value only 'number type' properties can be selected for this metric for example the chart will show the price of the cheapest car that was sold on a certain day this metric is not available in pie charts you can use multiple metrics in one chart (not in pie charts) adding a new metric will add a new graph aggregation aggregation determines how values are displayed on the x axis there are two types of aggregation date histogram and aggregation by terms, date histogram this type of aggregation will display the change of values over time in the settings of the histogram, you can choose a 'date type' property of the entity that was chosen in the 'target' section you should also choose a minimum interval from one hour to one year if, for example, the day is selected, all items that were created in one day will be displayed on one point of the chart terms aggregation this type of aggregation will group values on the x axis by terms in the settings, you can choose a property that will be used for aggregation, the order of values (alphabetical or by count), and the maximum items that will be displayed on the screenshot belove you can see the graph with the size set to two sub aggregation you can add a second layer of aggregation to the existing one to do that, you need to click on the 'add sub aggregation' button the sub aggregation will create multiple graphs depending on the settings of the aggregation example we have a chart with the email logs that are aggregated by date we then can aggregate this chart by statuses of email logs using the aggregation by terms by applying the sub aggregation we are splitting one graph into several new graphs aggregated by email statuses filters you can filter data before forming a chart (for example you can exclude electric cars from a summary) here you can select any property and its condition you can set multiple conditions there are two modes for filters with multiple conditions all this mode will show records that meet all set conditions any this mode shows records that meet any of the set conditions example of usage i want to form a chart from email logs with the 'open' status that were created after 10 01 2021 the filter will look like that