Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
i have a problem to visualize the time series forecast output from Alteryx by using Qlik sense desktop (forecast for 30 days). in this pictures, you guys see the historical data and the time series forecast output, when i put 2 files into Qlik sense the association between historical data and output time series are really weak and it couldn't the visualization the output that i want. Can anybody give me the ideal for this problem ?
Table 1: Output data (from 1/1/2019 - 30/1/2019)
forecast_oil | forecast_oil_high_80 | forecast_oil_high_70 | forecast_oil_low_70 | forecast_oil_low_80 | Date |
88.43885269 | 90.49591758 | 90.10246951 | 86.77523587 | 86.38178779 | 01/01/2019 |
88.42331147 | 90.57986667 | 90.16738941 | 86.67923354 | 86.26675628 | 02/01/2019 |
88.41817846 | 90.66983222 | 90.23916577 | 86.59719115 | 86.1665247 | 03/01/2019 |
88.41807696 | 90.76097239 | 90.31285444 | 86.52329948 | 86.07518154 | 04/01/2019 |
88.43122288 | 90.86193745 | 90.39702262 | 86.46542314 | 86.00050831 | 05/01/2019 |
88.39221586 | 90.90768553 | 90.42655987 | 86.35787185 | 85.8767462 | 06/01/2019 |
88.44428429 | 91.04174497 | 90.54493716 | 86.34363142 | 85.84682362 | 07/01/2019 |
88.46772114 | 91.15396233 | 90.64017377 | 86.29526851 | 85.78147994 | 08/01/2019 |
88.40670544 | 91.17265958 | 90.64362458 | 86.16978629 | 85.64075129 | 09/01/2019 |
88.44180398 | 91.28523728 | 90.74138309 | 86.14222488 | 85.59837069 | 10/01/2019 |
88.44539141 | 91.36424794 | 90.8059678 | 86.08481502 | 85.52653488 | 11/01/2019 |
88.46213092 | 91.45451024 | 90.88216764 | 86.0420942 | 85.4697516 | 12/01/2019 |
88.40170488 | 91.46584335 | 90.87977561 | 85.92363415 | 85.33756641 | 13/01/2019 |
88.40599657 | 91.54025168 | 90.94077296 | 85.87122018 | 85.27174145 | 14/01/2019 |
88.42313887 | 91.66586635 | 91.04564048 | 85.80063727 | 85.18041139 | 15/01/2019 |
88.42313887 | 91.74344094 | 91.10837762 | 85.73790012 | 85.1028368 | 16/01/2019 |
88.42313887 | 91.81924401 | 91.16968209 | 85.67659565 | 85.02703373 | 17/01/2019 |
88.42313887 | 91.89339166 | 91.22964776 | 85.61662998 | 84.95288608 | 18/01/2019 |
Table 2: Historical data (from 2011 - 2018)
Date | Price of Crude Oil/ barrel (USD) |
01/01/2011 | 92.19 |
02/01/2011 | 92.54 |
03/01/2011 | 92.86 |
04/01/2011 | 92.76 |
05/01/2011 | 92.91 |
06/01/2011 | 92.79 |
07/01/2011 | 92.20 |
08/01/2011 | 92.93 |
09/01/2011 | 92.66 |
10/01/2011 | 92.28 |
11/01/2011 | 93.01 |
12/01/2011 | 92.29 |
13/01/2011 | 92.62 |
14/01/2011 | 92.73 |
15/01/2011 | 92.76 |
16/01/2011 | 92.50 |
17/01/2011 | 92.77 |
18/01/2011 | 92.40 |
19/01/2011 | 92.46 |
20/01/2011 | 93.06 |
21/01/2011 | 92.50 |
22/01/2011 | 92.49 |
23/01/2011 | 92.92 |
24/01/2011 | 92.52 |
25/01/2011 | 92.42 |
Hi,
Not sure what the problem is, but have a look into YEAR... your forecast has 2019, but historical file 2011. Do you want to put them on the same graph with a gap in 8 years?
//Andrei
i have full historical data from 2011 - 2018( day,month and year) and i use the time series forecast in Alteryx to get the output forecast for 2019 (forecast by day). But i don't know the way to visualize the output connect with the historical data