Transformations in charts

Charts make easier the visualization of your data but also make easier some adjustments to show exactly the data in the way you want. These adjustments are:

• Aggregation
• Grouping
• Filter (coming soon)
• Truncate dates (coming soon)

Aggregation

Allow calculating the numeric data selected. For example, if we select a column called price applying a count we get the number of cells of each category but by applying a sum we will get the total price of each product category by adding up all the values.

In other cases, maybe the data was calculated previously, so this aggregation wouldn’t be necessary.

The options that aggregation has are:

• sum (sum all the values from the selected column)
• count (count the rows from the selected column, repeated values count as many times as they appear)
• count distinct (count the rows from the selected column, repeated values count as one)
• average (give the average value from the column selected)
• min (return the lower value from the column selected)
• max (return the highest value from the column selected)

info

☝ Note that Aggregation is only available for the numeric data of your chart.

Grouping

A chart needs numeric data and a category or a date to group those numbers. There are situations where we need to look at the details of the numbers. For this reason, some charts allow grouping the numeric data by another value.

For example, we want the number of titles (numeric data) over the years. This would return a total number by year, like 45 in 2023. If we want to know the title type, movie, or tv show, of those 45 movies, we can apply a grouping in the numeric series by the genre column.

info

☝ The column to make that grouping has to be in the block connected to the visualization block.