-
Re: How can I forecast for next three months using the below data?
Sunny Talwar Feb 8, 2018 12:19 PM (in response to Niteen Kumar )Would you be able to share the qvf where you are trying this? Will be easy to troubleshoot from there
-
Re: How can I forecast for next three months using the below data?
Sunny Talwar Feb 10, 2018 7:49 PM (in response to Niteen Kumar )Hi Niteen -
I see you are only loading data until 2017-sep. If you won't have oct, nov, and dec in you app, they won't get calculated. Now this may be how it is only in the sample app, whereas your original app might have it. But this would be a good starting point to check. Do you even have those three months in your application or not?
-
Re: How can I forecast for next three months using the below data?
Niteen Kumar Feb 11, 2018 4:36 PM (in response to Sunny Talwar )Hi Sunny, I don't have the next three months (oct/nov/dec) in my app and that is precisely my question. How can I show next three month and the corresponding predicted count of tickets based on the last three month ticket data? These data files are monthly files with count of tickets
Cheers, Niteen.
-
Re: How can I forecast for next three months using the below data?
Sunny Talwar Feb 12, 2018 11:25 AM (in response to Niteen Kumar )Just concatenate those three into your main field
Table:
LOAD
"Incident ID",
"INC Closed Time"
FROM [lib://Downloads/Ticket Forecasting Problem.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate (Table)
LOAD Date(Date#("INC Closed Time", 'DD/MM/YYYY')) as "INC Closed Time"
INLINE [
INC Closed Time
01/10/2017
01/11/2017
01/12/2017
];
-
Re: How can I forecast for next three months using the below data?
Niteen Kumar Feb 12, 2018 11:38 AM (in response to Sunny Talwar )Thanks Sunny. With your help i managed to get the months as a dimension. How about calculating the foretasted value for these months? How should the formula look like. Thanks again.
Cheers, Niteen
-
Re: How can I forecast for next three months using the below data?
Sunny Talwar Feb 12, 2018 11:51 AM (in response to Niteen Kumar )I think your initial formula should work... if it isn't would you be able to share the app with those dates in the app?
-
-
-
-