Next, add an if-then-else column to your Log table:
– If training date is on or after Monday (math column), then true
Finally, use a rollup column to count the number of true values in the if-then-else column.
There is the same types of trainings for all users.
There is only 85 lines on my tab “Training sessions” so, only 85 trainings sessions;
One session has only one type of training;
I have 5 types of trainings.
One IF column named “Type d’entrainement” with all the types of my trainings.
One “total entrainements” column with all the training from the start.
I created a boolean column by type of training (true/false) to get the number from one specific type of training.
I have one roll up field with the number of all trainings, called “Type d’entrainement”.
There is one video :
My current chart with figures that do not correspond at all to reality (I only have 85 training sessions).
Okay. I would probably do this a little differently.
What I would suggest is to create a “Training Types” table. This needs a column with one row for each type of training. Then create a multiple relation from this table to your Training Log table, matching the training type in each. Then add a rollup->count via that relation. Then use this table as the source for your chart.