multiple line graph with single x-axis

drewfig

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!

BlueRooster

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.

 

 

BlueRooster

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.

 

 

drewfig

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