When you run the prompt Show sales by store for this financial year as pie chart right at the start, the app does not render the chart. However, if you ask the same prompt again, it works as expected.
This isn't a major concern, as it also provides an opportunity to trace with Foundry, which is interesting.
From what it looks like, this appears to be related to instruction following or agent not knowing the database schema and types.
- The first run uses the date filter with 'YYYY-MM-DD'
- The second run uses the date filter 'YYYY'
Maybe we can put the database types descriptions in the MCP server as a tool (make it dynamic), or else put it in the agent instructions, but that would fixate the schema.
Thanks