Every Friday I have a task running that stores data (eg. stat date, total clients, total prospects etc) for our various franchises.
For the logged in Franchise, I want to display the figures for each year as a separate series for comparison purposes. Instead of using the date on the x-axis, I created another field to calculate the week of the year. So ideally, I want "Week Number" on the x-axis, "Total Clients" on the Y-axis, and "Series one" being 2019 totals and "Series two" 2020 totals.
I can create separate charts for each year by filtering the source records, but how do I display the info on one chart?
Help would be appreciated.