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
Community Champion
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
- Vvelarde
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!
