Guys, I have a very simple output that looks like:
| week |
car |
total |
broken |
| 31 |
Volvo |
100 |
20 |
| 31 |
Hyundai |
130 |
10 |
| 31 |
Ford |
240 |
44 |
| 32 |
Volvo |
98 |
15 |
| 32 |
Hyundai |
143 |
7 |
| 32 |
Ford |
238 |
52 |
What I need is a linechart where X-axis is week number and there are 2 lines per product - total and broken.
This works for one, but not sure how to include the other:
query | chart values(broken) by week, car
