AnsweredAssumed Answered

Line graph with several data sources

Question asked by luis.ecohaus on Aug 4, 2017
Latest reply on Aug 7, 2017 by luis.ecohaus

Hi all,

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):

Screen Shot 2017-08-04 at 12.28.06.png

.. and the last line:

Screen Shot 2017-08-04 at 12.28.11.png

gStartDate, gEndDate and gStatus are global fields which I can manipulate, giving them different values.

 

This is my graph Data source settings:

Screen Shot 2017-08-04 at 12.32.29.png

This is my chart settings showing both X-Axis and Y-Axis values:

Screen Shot 2017-08-04 at 12.33.19.png

 

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.

 

Thank you.

Outcomes