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
-
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.0
Answers
-
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.0 -
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 Seriesfiscal_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
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive