Hello,
i need help for a simple example. There are the following data from different runners. I got a table from each person.
I want to create to diagrams. The first show for all Runners the Number of Runs, the Duration of Runs, the Rank for each discipline. I want to see the average value and the max Value.
The second diagram show the result for each Runner, for each Run.
The timestamp at the x-axis. A bargraph for each run with the Value of the duration and Number of run and rank as labeling of the bar.
Runner 1:
| Timestamp | ValueName | Min Value | Max Value | Avg Value |
|---|
| 00:00:10:00 | Number of 100m-Run | | 1 | |
| 00:00:10:00 | Duration of 100m-Run | | 100s | |
| 00:00:10:00 | Rank of 100m-Run | | 29 | |
| 00:00:30:00 | Number of 500m-Run | | 1 | |
| 00:00:30:00 | Duration of 500m-Run | | 500s | |
| 00:00:30:00 | Rank of 500m-Run | | 3 | |
| 00:00:50:00 | Number of 500m-Run | | 2 | |
| 00:00:50:00 | Duration of 500m-Run | | 300s | |
| 00:00:50:00 | Rank of 500m-Run | | 2 | |
| 00:01:50:00 | Number of 100m-Run | | 2 | |
| 00:01:50:00 | Duration of 100m-Run | | 120s | |
| 00:01:50:00 | Rank of 100m-Run | | 35 | |
| Number of 100m-Runs | 1 | 2 | 1,5 |
| Number of 500m-Runs | 1 | 2 | 1,5 |
| Duration of 100m-Runs | 100s | 120s | 110s |
| Duration of 500m-Runs | 300s | 500s | 400s |
| Rank of 100m-Runs | 29 | 35 | 32 |
| Rank of 500m-Runs | 2 | 3 | 2,5 |
Runner 2:
| Timestamp | ValueName | Min Value | Max Value | Avg Value |
|---|
| 00:20:10:00 | Number of 100m-Run | | 1 | |
| 00:20:10:00 | Duration of 100m-Run | | 80s | |
| 00:20:10:00 | Rank of 100m-Run | | 20 | |
| 00:20:30:00 | Number of 500m-Run | | 1 | |
| 00:20:30:00 | Duration of 500m-Run | | 400s | |
| 00:20:30:00 | Rank of 500m-Run | | 2 | |
| 00:20:50:00 | Number of 500m-Run | | 2 | |
| 00:20:50:00 | Duration of 500m-Run | | 300s | |
| 00:20:50:00 | Rank of 500m-Run | | 1 | |
| 00:21:50:00 | Number of 100m-Run | | 2 | |
| 00:21:50:00 | Duration of 100m-Run | | 100s | |
| 00:21:50:00 | Rank of 100m-Run | | 22 | |
| Number of 100m-Runs | 1 | 2 | 1,5 |
| Number of 500m-Runs | 1 | 2 | 1,5 |
| Duration of 100m-Runs | 80s | 100s | 90s |
| Duration of 500m-Runs | 300s | 400s | 350s |
| Rank of 100m-Runs | 20 | 22 | 21 |
| Rank of 500m-Runs | 1 | 2 | 1,5 |
