looker-open-source / looker-explore-assistant

A React Application for interacting with Looker data through natural language.
MIT License
83 stars 52 forks source link

Incorrect filtering in rendered explore but correct link/output given #67

Open stuart-harrison opened 1 month ago

stuart-harrison commented 1 month ago

Using the chatbot I have encountered a weird issue that I cant debug. I have the chatbot itself up and running producing reports.

However, if I ask the chatbot to look at for example 'total transactions in last 90 days' the rendered report in the UI will give me the 90 days in the matches advanced section. See screenshot below, this produces an invalid syntax error and the report can not be generated. When I click the link or look at the llm output in the dev console both are correct and produce the report I am looking for - In the last 90 days (second screenshot)

I cant quite debug this, can anyone help / explain what is going on here? thanks in advance.

Screenshot 2024-07-18 at 17 06 31 Screenshot 2024-07-18 at 17 08 06