# Edit/delete bad data in pageview graph

**URL:** https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801
**Category:** Support
**Created:** [January 7, 2024, 7:03pm UTC](https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801 "2024-01-07T19:03:11Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![JonahAragon1](https://avatars.discourse-cdn.com/v4/letter/j/f19dbf/32.png) [@JonahAragon1](https://meta.discourse.org/u/JonahAragon1)
#### Post date: [January 7, 2024, 7:03pm UTC](https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801/1 "2024-01-07T19:03:11Z")

</div>

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](https://global.discourse-cdn.com/meta/original/4X/4/a/6/4a6bafcee68c237dc293ada1ee1ef9f89ece6249.png)

---

<div class="post-metadata">

### Author: ![jericson](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jericson/32/116215_2.png) [@jericson](https://meta.discourse.org/u/jericson)
#### Post date: [January 7, 2024, 9:44pm UTC](https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801/2 "2024-01-07T21:44:10Z")

</div>

I’d look at deleting some rows from `application_requests`, based on [the query that drives that report](https://meta.discourse.org/t/dashboard-report-consolidated-pageviews/289263). Something like:

```plaintext
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.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [February 6, 2024, 9:44pm UTC](https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801/3 "2024-02-06T21:44:22Z")

</div>

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