'SQL Type' Queries on workout data but in an easier to use way
This seems a little advanced and might need a little thinking about but I'm sure there a plenty of people out there wanting to analyse their data a little more in depth. What i'm proposing training peaks creates a 'query library' or something to that effect where athletes can build there own query's. This can then be applied to a workout and results displayed. Rather than using SQL, a basic language can be created to recognise commands such as 'where workout distance >1 mile and <5.25 mile calculate average speed, average heart rate'. This is just a basic example of say a workout being posted with a mile warm up and a 4.25 mile run and some additional cool down info. The query looks at the workout and calculates the info from the 4.25 mile run period, disregarding the warmup and cooldown. I'm sure the queries people would create could be far more advanced than this. The language doesn't have to be complex just a few keywords so that everyone could use it. This would be great in say interval training for working out performance in each interval. Maybe the queries could be done on multiple workouts or even through a specified time period. The possibilities are endless.
Functionality like this will find its way into our WKO desktop application and then trickle down into the web-app. The ETA for both is TBD at the moment.
-
Poseidon2600 commented
Curious if this had any consideration since 2014? It would still be very helpful functionality