Hey team, we're facing a problem in one of our visualizations. As you can see in the screenshot (which was taken a couple of days ago within April), we have two records that even though they shouldn't appear (since we have chosen

Last Month

in the date filter), they still do. My guess is that issue might be similar with the one we had around March and had to do with the time change. Can you please take a look?

Hi Èvangelos, it does seem that this is the same issue here again. Coud you please send me vis DM and explainAfm.zip file so I can confirm our suspisions. We provide AFM explain resource available for low-level inspection what queries are being sent to a database. It can be used also from browser, if you open the specific report using “Analyze” tab and replace the last URL part (

/edit

) with

/debug

. It will download a ZIP archive “explainAfm.zip” containing low-level information about report and its computation, including report.json.qt.opt.sql with actual query that was sent to your database. Thank you in advance for this!

Sent you a DM @Michael Ullock 😊