Edit/delete bad data in pageview graph

support
2

I’d look at deleting some rows from application_requests, based on the query that drives that report. Something like:

DELETE
FROM application_requests ar
WHERE req_type = 8 
    AND ar.date::date BETWEEN :start_date AND :end_date;

It’s always best to SELECT * (or similar) first to make sure you are getting the right data. Probably you can find something to identify illegitimate requests besides the req_type and date.

2 Likes