Hi !

I have a table named "Activités" in which I add records that are appointments with my clients. Each appointment corresponds to a service which is selected from an N:1 field from another table named "Produits et services".

Each service in the "Produits et services" table is itself linked with an N:1 field to a category from a table named "Catégories de produits et services".

Where each appointment (Activités) corresponds to a service (Produits et services) which is itself linked to a category of service (Catégories de produits et services).

From my dashboard, I currently have a graph that allows me to display the number of appointments by service category and it works well. However, each time I add a service category in the "Catégories de produits et services" table, I have to manually create a new column in the chart with the calculation formula for this new category.

Is there a way to make the graph automatically take into account new categories (new records)?

Thanks for your help !

let filterStart := 'Début du filtre';
let filterEnd := 'Fin du filtre' + 1;
select 'Activités'
    where date('Date du rendez-vous') >= filterStart and
        date('Date du rendez-vous') <= filterEnd and
    Statut = 6