Can you tell me how group by works in Obsidian? I am trying to sum up my minutes of workouts each day. It seems simple enough but I am not getting the Sum correctly.
TABLE sum(rows.exercise) as WorkoutMinutes
WHERE exercise != null
GROUP BY file.name
I want to build a chart from my workout data over time but I don’t think this would work from obsidian chart data input. Please help - thank you so much 
