Forum Discussion
Gauge Chart Help - Dynamic Maximum Value
HI, create a relationship between the tables.
You can change the slicer to use The Name of the 3rd Table.
Regards
Victor
Hi, try doing this:
1. In Edit Query create a IDColumn (The Same in both Tables):
Close & Apply
2. Related the tables using the IDColumn (Both Direction)
3. Create the visuals
and Finally the Gauge Chart
Hope this can help you
Regards
Victor
Lima - Peru
Hi Victor,
Thanks for your explanation and help! Apologies I made a mistake in my question. There is a third table which contains the indvidual athlete information so the 3 tables looks as follows:
| Name | Exercise | Date | Reps | Sets | Max Weight |
| James | Squat | 24.08.2017 | 5 | 5 | 100 |
| James | Bench Press | 24.08.2017 | 5 | 5 | 80 |
| James | Press Up | 24.08.2017 | 10 | 4 | 10 |
| James | Deadlift | 24.08.2017 | 5 | 5 | 100 |
| James | Bench Row | 24.08.2017 | 10 | 4 | 80 |
| Jeff | Squat | 21.08.2017 | 5 | 5 | 75 |
| Jeff | Bench Press | 21.08.2017 | 5 | 5 | 65 |
| Jeff | Press Up | 21.08.2017 | 10 | 4 | 5 |
| Jeff | Deadlift | 21.08.2017 | 5 | 5 | 90 |
| Jeff | Bench Row | 21.08.2017 | 10 | 4 | 70 |
| Jim | Squat | 21.08.2017 | 5 | 5 | 75 |
| Jim | Bench Press | 21.08.2017 | 5 | 5 | 65 |
| Jim | Press Up | 21.08.2017 | 10 | 4 | 10 |
| Jim | Deadlift | 21.08.2017 | 5 | 5 | 110 |
| Jim | Bench Row | 21.08.2017 | 10 | 4 | 65 |
| Position | Age | Exercise | Target |
| Forward | Senior | Squat | 120 |
| Defence | Senior | Squat | 110 |
| Forward | U19 | Squat | 90 |
| Defence | U19 | Squat | 80 |
| Name | Position | Age |
| James | Forward | U19 |
| Jeff | Defence | Senior |
| Jim | Defence | Senior |
This there still a way I can do this using the method you've described below?
Many thanks,
James
HI, create a relationship between the tables.
You can change the slicer to use The Name of the 3rd Table.
Regards
Victor
Perfect! Thanks for your help!