Hello, I am trying to build a copilot which allows users to ask questions about financial health levels in different industries. I have given the Knowledge section a file with a series of text sentences like this:
The average operating margin in French supply chains in 2023 was X%.
The average operating margin in Italian supply chains in 2023 was X%.
The average operating margin in Japanese supply chains in 2023 was X%.
The average operating margin in French supply chains in 2022 was X%.
The average operating margin in Italian supply chains in 2022 was X%.
The average operating margin in Japanese supply chains in 2022 was X%.
Previosuly I tried providing the data in a table, but it didn't work well, so I've converted the data into something more readable.
When I ask a question like which country had the lowest average cash ratio in 2023 it sometimes get's it right, but sometimes it just picks another country and gives a clearly incoprrect answer. If I ask it to list all countries with a ratio below X, it picks a couple but never gets them all.
I don't understand why it can't get the questions right when I have loaded the specific data as a Knowledge resource.
Is there a microsoft product which will do a better job of reading data tables?