I'm trying to create a multi-series chart as described here. However, my issue is that I want two series displayed on the same chart with both using the same field. I have:
- A DateTime field showing the date and time of inspections.
- I wish for one series to be a bar chart showing the total number of inspections per day (date). I can do this by setting the minimum period to "day".
- On the same chart I'd like a line series to show the breakdown of inspections collected by hour (time). Again, I could do this by setting the minimum period to "hour"
How do I create two series on the same chart, from the same variable?