Hi,
I have a table as follows:
| Satisfaction | Value | Environment | Team | Date |
| 8 | 8 | 9 | A | 10/03/2019 |
| 3 | 8 | 9 | B | 09/03/2019 |
| 7 | 4 | 1 | A | 11/03/2019 |
| 3 | 3 | 3 | A | 11/03/2019 |
| 10 | 10 | 10 | B | 11/03/2019 |
and want to create a graph to summarize that information....grouping and averaging by team and date, and filtering by Team.
So the final table should look like this:
| Satisfaction | Value | Environment | Team | Date |
| 8 | 8 | 9 | A | 10/03/2019 |
| 5 | 3,5 | 2 | A | 11/03/2019 |
| 7 | 4 | 1 | B | 09/03/2019 |
| 3 | 3 | 3 | B | 11/03/2019 |
but the graph should only show team A or B depending on user selection.
I have been playing with the Items property of my LineChart, but can't make it work.
Any ideas?
Thanks!
M.
