<< Back to Education centre

See how to create your own charts from data in Caflou:

🙏 The feature is in beta version and despite its great potential, it is possible that it will have flaws and limitations. If you encounter a flaw or bug, please let us know via the in-app chat.

💡 Tip 1: Aggregated data

Any chart where you use a date attribute on the X-axis (e.g. payment or due date, date of timesheet or tracked time, task or project start or end date, etc.) can now be aggregated as follows:

  • by year
  • by month
  • by weeks
  • by days
  • by day of the week (e.g. for reports where you can see which days of the week are the most/least worked) 

If you select an attribute for the X-axis that is a date, then you get a new option in the report definition form to select a value for "Aggregation of dimension X"

💡 Tip 2: Cumulation of aggregated data

If you use aggregated reports (see Tip 1), you have the option to cumulate the values in the chart (option "Cumulate dimension X"). That is, the value for the previous period is added to the value for the following period (e.g. when aggregating by years, the year 2022 contains the values for 2022 and also for all previous years, if such data exists for the report).

💡 Tip 3: Data sorting by value

If you want to sort the information on the X-axis according to its value (e.g. amounts or counts from the highest value to the lowest), then use the "Sort" option where you can choose:

  • Automatic (the system will use the default sorting logic for the X-axis dimensions, e.g. alphabetically, by date, etc.)
  • In ascending order of dimension Y values (the system will sort the chart from the left from the lowest value to the highest)
  • In descending order of dimension Y values (the system sorts the graph from the left from the highest value to the lowest)

💡 Tip 4: Comparing multiple sources/datasets in bar and linear graphs

If you want to compare multiple sources of data in one chart, e.g. employee performance, salespeople comparison, or compare expenses from different categories, etc., you can "Add dataset" in the report settings. This will allow you to add another filter to the chart settings that will just determine the next set of data. Multiple such sets can be added to the chart.

In a bar chart, each data set then has its own color-coded columns. In a linear chart, each set then has a color-coded line. The graphs then also have a legend identifying the color of each data set. 

Graphs with multiple data sets

Graphs with multiple data sets