# Dashboard Report - Topics with No Response

**URL:** <https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002>\
**Category:** Data & reporting\
**Tags:** sql-query, dashboard-reports, dashboard-sql\
**Created:** [February 2, 2024, 10:55pm UTC](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002 "2024-02-02T22:55:48Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![SStrong](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@SStrong](https://meta.discourse.org/u/SStrong)\
**Post date:** [July 2, 2024, 3:43pm UTC](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002/2 "2024-07-02T15:43:24Z")

</div>

> [@SaraDev](#):
>
> ```plaintext
> -- [params]
> -- date :start_date = 2024-01-01    
> -- date :end_date = 2024-02-01
> -- null int :category_id
> -- boolean :include_subcategories = false
> 
> WITH no_response_total AS (
> SELECT *
> FROM (
> SELECT t.id, t.created_at, MIN(p.post_number) first_reply
> FROM topics t
> LEFT JOIN posts p ON p.topic_id = t.id AND p.user_id != t.user_id AND p.deleted_at IS NULL AND p.post_type = 1
> WHERE t.archetype <> 'private_message'
> AND t.deleted_at ISNULL
> AND (
> :category_id IS NULL
> OR t.category_id = :category_id
> OR (
> :include_subcategories
> AND t.category_id IN (
> SELECT id FROM categories WHERE parent_category_id = :category_id
> )
> )
> )
> GROUP BY t.id
> ) tt
> WHERE tt.first_reply IS NULL OR tt.first_reply < 2
> )
> 
> SELECT 
> DATE(nrt.created_at) AS date, 
> COUNT(nrt.id) AS topics_without_response
> FROM no_response_total nrt
> WHERE nrt.created_at::date BETWEEN :start_date AND :end_date
> GROUP BY date
> ORDER BY date ASC
> 
> ```

Are you able to make a version that does not contain parameters? I want to create a version which looks back 7 days to be then sent via email to people and struggling to use this code as there are parameters set in it

Thanks

---

_[View the full topic](https://meta.discourse.org/t/dashboard-report-topics-with-no-response/294002)._