I have a question that uses a SQL view to gather data. This data is aggregated by
date: week and is available from Sept 2020 to Sept 2021 and can be visualized on a line graph.
When clicking on a chosen point (let's say the first week of august) I am given the choice to view the related records. When doing so, "No results !" is displayed but if I choose to download full results as a csv for example, I can see the related records.
After doing some investigation, it appears that even if the data is visible from Sept 2020 to Sept 2021 in the table view or the line view, only the data from Sept 2020 to May 2021 can be "dug through". All data from May 2021 to Sept 2021 are just missing, except when downloading then as csv.
I have taken a look at the logs in the troubleshooting section but no errors is showing. The data is just truncated when zooming on the records.
Does this issue ring a bell ?