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!

Best Answer

  • Valiant
    Valiant 🔵
    Accepted Answer

    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:
    image.png

     

     

     

     

     

     

     

     

     

     

    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.

     

     

Answers

  • 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_yearordered_dateamount_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.