Hi all
I'm currently developing a report that will go out to other services within my workplace. In this report I need to create a chart that will compare each services figures for the month against that of the same month from the previous financial year.
There are roughly 6 services that I am reporting on and I need to have each one on the same chart, with last months performance against the performance of that service for the same month one year ago. I would like these two figures running side by side for each service.
The data looks like this:
| Financial Year | Date | Service | Number of responses |
| 18/19 | 2018-11-01 | Apple | 24 |
| 18/19 | 2018-11-01 | Orange | 8 |
| 18/19 | 2018-11-01 | Pear | 68 |
| 19/20 | 2019-11-01 | Apple | 32 |
| 19/20 | 2019-11-01 | Orange | 5 |
| 19/20 | 2019-11-01 | Pear | 72 |
The workflow is built out so multiple charting tools (or Interactive Chart if necessary) are running into a Visual Layout tool for organisation before being rendered.
Is this possible to do on a charting tool (preferable for my format)? If not is it possible on an Interactive chart tool?
Any help you can provide is greatly appreciated as I have really hit a wall here.
Thanks
Stu
