Chart all entries for one item

Ask for Help
1

I have a physical workout app. I have a table that logs all workouts with individual columns used to collect:

  • date
  • Exercise 1 name
  • Exercise 1 reps
  • Exercise 1 sets
  • Exercise 1 weight
  • Exercise 2 name
  • Exercise 2 reps
  • So on…….

I am trying to create a chart that will show all entries for a particular exercise and the weights used across dates.

How do I gather all the information for that particular exercise and the associated weights used?

Do I make one chart per exercise or have a filter to change exercise?

I’ve run out if ideas.

2

I think you would have it much easier to aggregate data if you make it this way.

Date Exercise Name Reps Sets Weights
13 Sep 2024 Exercise 1 1 1 50

Then, you can use a relation/query to get all entries for a particular exercise and display them using a chart.

1 Like
3

Sorry I explained it wrong that is how I have it setup, each in its own column not row.

So how do I know collate the data for a particular exercise and chart it?

4

Could you provide a screen shot of your logs table, just so we are absolutely clear on the structure?

Also, do you have a separate table that lists all the unique exercises?

5

Thanks Darren, good idea.

Here is the Workout Log table that collects data for each workout:

image.png
image.png1237×199 25.2 KB

I also have an Exercise table which in the layout is setup as a drop-down list to select which exercise you completed:

image.png
image.png1104×182 32.5 KB

So how do I now set up a Relation or Lookup or whichever so that a Chart can grab all “Bench Press” completed along with the reps, sets and weights used by Bench Press to display a Chart that shows something similar to the below - but for the history of that one exercise?

image.png

6

Okay, thanks. Yes, it’s as I suspected. Your Workout Logs table is not normalised.

My suggestion would be to first change that so that you have one row per user per exercise (as per what was suggested by @ThinhDinh). That is, get rid of the “Exercise2”, “Reps2”, etc columns.

If you do that, it will be a lot easier to work with. All you will need is a Query column in your Exercises table that targets the Workout Logs table and filters by This row->Name, and then you can do rollups through that Query to get the stats you need.

1 Like
7

Sorry does that mean have a new table for Exercise 2? Then another table for Exercise 3?

8

No, have them all in the same table, but in separate rows.
If you need to know the exercise number, then add one extra column to record that.

1 Like
9

Great thanks everyone makes sense