Our model is just able to perform till the 2nd step and not beyond that. We are using function calling. It retrieved all the required data but not able to perform 4, 5, 6, 7, 8 steps. I have attached the prompt response file.
Prompt: what is the sales performance for product Claire at Region level
Answer: Executing the following steps to get the sales performance for product Claire at Region level: 1. Get the time periods for 1st to 9th week previous weeks from current week.
2. Calculate the sum of value Actual Shipments Quantity, Demand plan, prior year shipments from 1st weeks to 9th weeks values for each "Regio
3. Calculate percentage change in growth of demand plan for 9 weeks trend of Actual Shipments Quantity, Demand plan for each “Region”.
4. Calculate percentage change in growth of prior year shipment for 9 weeks trend of prior year shipments, Actual Shipments Quantity, of each "R
5. Calculate percentage change in growth of demand plan, Calculate percentage change in growth of prior year shipment for 4 weeks trend and
6. Get the actual shipment Quantity for the time of “year value” of current week at “Region” level.
7. Calculate the proportion of each region for year value of current week.
8. Analyze the trends in %Demand Plan Growth and %Prior Year Shipment Growth for each “Region” of 9 weeks trend, 4 weeks trend prior week trend.