I have a line graph working perfectly showing the number of leads per month. It is also dynamically according to a start date and end date, and the lead status I choose. It is working using a relationship.
What I want to achieve? I would like to have one or two additional lines on the graph referring to the last two financial years. The issue is I don't know how to show more than a set of data in the same line graph.
As I said I can make it work for a single set of data.
This is my current relationship (5 criteria):
.. and the last line:
gStartDate, gEndDate and gStatus are global fields which I can manipulate, giving them different values.
This is my graph Data source settings:
This is my chart settings showing both X-Axis and Y-Axis values:
It might be possible to achieve what I want with SQL queries. I don't think I can achieve the goal using relationships as the graph itself only lets me choose one data source. However, I might be wrong.