The Chart View has the same advanced data aggregation abilities as the Pivot Table View. It just displays the results in a chart. At the moment, this can be a line chart, a bar chart, a pie chart, and a bubble chart.
We are adding more chart types to the Chart View as per user requests.
There can be two independent Y axes in a line or bar chart and the chart is interactive. It can be zoomed or scrolled by mouse.
Even the data points can be directly moved by a drag of a mouse when they do not come from an aggregation of several values.
The chart can aggregate data across connected tables. It means that one table can contain the data sets and the other one can hold individual values for the data set. Multiple data sets can be displayed at once.
Another type of supported Chart View type is a bubble chart that can be used to display one more visual attribute. That is a size of the bubbles. This is useful for visually demonstrating employees efficiency as a punchcard.
The Chart View can of course work with most data types like number, percentage, duration, date and time, selection, email, color and checkbox.