Edit/delete bad data in pageview graph

Okay, this is a relatively minor issue, but is there a way to remove or edit a day’s worth of data on the pageviews graph/report?

My forum was just DDoSed, and while that was fixed with a switch to Cloudflare, the scale of my graph on the admin dashboard is sadly ruined now:


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

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.


This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.