on 09-26-2017 5:33 PM
Hi experts:
Getting error msg during the time series analysis as there are two values associated with same date. I am taking data from HANA DB.so how can we aggregate the dates ?? should that be handled on modelling side?? or can we do on predictive Modeler side of Predictive tool to get rid of the error
Hi Neeraja,
does it make sense (from a business standpoint) to aggregate the two values corresponding to the date?
Kind regards,
Antoine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pierrick, can you please describe in detail what you want to achieve? If you want to forecast a quantity that depends on both customer and product variables you need to organize your dataset as follows:
Customer ID Product ID Date Quantity
Then specify the multiple rows.
The tool is saying that per segment (here each segment is a combination or crossing of customer * product) you need to arrange the rows so that the date is strictly increasing which ultimately is a matter of data sorting per segment not aggregation.
Kind regards Antoine
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.