This is an SQL version of the Dashboard Report for Topics with No Response. The dashboard report is designed to count the number of topics created within a specified date range that have not received any responses from other users. This report can be filtered by a specific category and can optional…

[صورة] Sara Devlaeminck: -- [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 …

[صورة] Sophie Strong: Are you able to make a version that does not contain parameters? Yes, here’s an updated version of the query that looks back 7 days from the current date without using parameters. :slightly_smiling_face: This version does not include any filtering by categories or subca…

Thanks for the response, I’ll come back to this when I next need it as the focus has now shifted to something else so not had the time to come back to this

Hey there, I’m really struggling to be able to turn this into not date driven, but month year. I’ve done multiple things to try and make this work, but it keeps telling me that the column doesn’t exist (when it does as I’ve just created it within a with statement, and then subsequently am referenc…

Hi Sophie, [صورة] Sophie Strong: How would someone amend this code so instead of looking at topics with no response day by day, we would be able to see it Year by Year, Month by month etc. To modify the query so that it can aggregate topics without responses by year, month, or other time int…

Thanks, that’s resolved the how to get the year piece. I’m now stuck again as dates in postgre seem to behave differently to_char(t.created_at, ‘MM-YY’) as Yearmonth, This is giving me 10-22 which represents “Oct-22” How am I able to change 10-22 to Oct-22? I have tried to look at guidance withi…

[صورة] Sophie Strong: How am I able to change 10-22 to Oct-22? To change the date format from 10-22 to Oct-22 in PostgreSQL, you can use the TO_CHAR function. This function allows you to format dates in various ways, for example: SELECT TO_CHAR(TO_DATE('10-22', 'MM-YY'), 'Mon-YY') AS format…

تقرير لوحة المعلومات - المواضيع بدون رد

مجتمع البيانات والتقارير

SStrong (Sophie Strong) 23 يوليو 2024، 7:24ص 4

شكراً على الرد، سأعود إلى هذا عندما أحتاجه مرة أخرى حيث تحول التركيز الآن إلى شيء آخر، لذلك لم يكن لدي وقت للعودة إلى هذا

الموضوع		الردود	مرات العرض
Dashboard Report - Time to First Response Data & reporting dashboard-reports , sql-query , dashboard-sql	0	445	14 ديسمبر 2023
'noreplies' reporting question Support	0	252	25 يناير 2023
Replicating the query behind 'topics with no response' Data & reporting sql-query	1	489	1 مارس 2023
Average Staff Response Times to Topics Data & reporting sql-query	3	255	3 مايو 2024
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	3	177	2 مارس 2025

تقرير لوحة المعلومات - المواضيع بدون رد

الموضوعات ذات الصلة