I've setup Azure Cognitive Search Service that is indexing JSON data from Azure Storage. This JSON contains core-fields after lot of JOIN Operations based on D365 Sales Data.
I've also setup Azure Open AI Service and have added above Cognitive Index as source in Chat Playground.
Here is the list of questions for which am expecting to have answers from Azure Open AI:
- What is the current year won opportunity amount for existing clients?
- What percentages of opportunities we won in 2023?
- How many of the above opportunities were with new clients?
- Which are the top three accounts by won opportunities in the current year?
- How does Q1 and Q2 compare in terms of opportunities won and opportunities created how does opportunities won YTD compare against YTD previous year?
Now here is the problem am facing. Whenever I write any of the above queries, Azure Open AI Is passing that statement "as-is" to Azure Cognitive Search defeating the whole purpose of converting English search language to appropriate search string in Cognitive Search.
How can I get accurate answers for above sample queries? Please help.
