Edit/delete bad data in pageview graph

support
1

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:

0Hp3ZN927mIPuRBJ
0Hp3ZN927mIPuRBJ2056×718 78.5 KB

2 Likes
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
3

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