Create a multiline demand forecasting graph

Question & Answer
, ,
1

Hi,
I would like to create a graph like this graph:

Screenshot 32
Screenshot 321460×638 120 KB

I have 2 datasets:

  1. Historical data for each product how many sold till a specific date
  2. Forecast data for each product I have 2 columns: lower or upper level

I want to join these tables by product id and create this graph the problem I’m encountering is that I that the x line can be only the dates of one of the tables (or the historical data dates or forecast dates)

I need to create a graph that starts from the first date in the historical data till the end date of the forecasted data.

Thank you in advance,
Idan

2

Can you left join on date as well and make one date for both tables?

Then you would have a “type” regular, upper, and lower.

Then you would have the unified date as the x-axis and the “type” as the color

1 Like
3

Hi Max,
Thank you for your quick replay, I have tried that and the dates range is not as expected:

Screenshot 35
Screenshot 351916×703 184 KB

The graph looks like this:
https://freeimage.host/i/HXH2ZWxhttps://freeimage.host/i/HXH2bfV

This is the forecasted table data - as you can see the last date is 31/12/2017 and in the graph is till 9/12/23:

Would appreciate your help :slight_smile:

4

Ah, try not to join on date.

And in SQL or quicksight run a case statement.

case when date is null then timestamp else date end

1 Like
5

Hi @PlanToIt,
We hope the reply from @Max worked for you.
Let us know if this is resolved. And if it is, please help the community by marking the reply as a “Solution.”
Many Thanks,
Andrew

1 Like