# 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:** 1
**Showing post:** 2

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

---

_[View the full topic](https://meta.discourse.org/t/edit-delete-bad-data-in-pageview-graph/290801)._