The Data is structured as: Date of Sale | Order Amt | Price of product | Qty.
Product A was sold independent of Product B(thus, 2 datasets), so dates do not match at certain instances, and entries are also not continuous do to the same reasons, both products may also have days of 0 sale.. so no entry at all.
Both products have sold for different prices at different moments, I want to see if the price drop of Product A affects the Qty sold of Product B, and vice versa.
Also the same for price increase.
In general the trend of Product A price to Qty of Product B.
I am confused how to tackle this problem.
