# multiple line graph with single x-axis

Hello,

I've been trying to create this card but it seems that I can only do a separate card for each y-axis that I have.

I attached the actual graph that I am trying to create, can someone provide tips on how to do it? or maybe I should just consider having 3 separate cards for each of my y-axis?

Thanks!

So the first thing you'll need to check is the format of your data as that will determine the best approach to creating the card you want.

If for instance your data looked like this:

Then the way to set this up would be to select your chart type (Line in this case), set your X-Axis to Date, your Y-Axis to Amount and the Series to the Order Length.

If your data is drastically different from this, if you'll just provide an example of how it is set up, I will be glad to help put you on the right track.

Hope this helps,

Colt

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

• This is a good solution, thanks. My data looks like the below table, any ideas on how to do it with this data?

I am currently using

(CASE WHEN

MONTH(`ordered_date`) IN (11,12,1) THEN AVG(`amount_total_in_usd`) * 12

ELSE 0 END) as my Y-axis

MONTHNAME(`ordered_date`) as my X-axis

(CASE when YEAR(`ordered_date`)= 2017 and MONTH(`ordered_date`) >=10 then 'FY18'
WHEN YEAR(`ordered_date`)= 2017 and MONTH(`ordered_date`) <10 then 'FY17'
when YEAR(`ordered_date`)= 2016 and MONTH(`ordered_date`) >=10 then 'FY17'
when YEAR(`ordered_date`)= 2016 and MONTH(`ordered_date`) <10 then 'FY16'
when YEAR(`ordered_date`)= 2015 and MONTH(`ordered_date`) >=10 then 'FY16'
else 'older than FY16'
End) as my Series

 fiscal_year ordered_date amount_total_in_usd 2016 1/23/2016 9:04 77.87 2016 3/18/2016 11:22 79.67 2016 7/4/2016 11:05 78.77 2017 5/22/2017 0:00 6,140.48 2017 11/4/2016 0:00 116.67 2016 8/19/2016 6:40 78.77 2016 9/8/2016 9:39 0 2017 11/17/2016 6:51 80.78 2017 2/25/2017 5:41 0 2017 4/19/2017 8:56 82.67 2017 5/16/2017 11:54 83.48 2017 6/14/2017 7:57 0
This discussion has been closed.