This is an SQL version of the Dashboard Report for Likes. This query provides a report of the total number of likes given to all posts on a site, on a day-to-day basis, within a specified date range. -- [params] -- date :start_date = 2023-12-08 -- date :end_date = 2024-01-10 WITH date_range AS ( …

Does this one need a AND pa.deleted_at IS NULL to filter out the Likes cast and then removed to marry up, or would that be a possible change to the dashboard query itself?

As it is currently, the dashboard report does include deleted likes, so adding AND pa.deleted IS NULL would change how this query is matching up with the dashboard report. Modifying the underlying dashboard report to not include deleted likes could be a good change to consider making to the report …

My forum isn’t very big, and most of our like reactions come from “staff” (admins, moderators, TL=4). I wanted to see how likes from regular users vs “staff” compared, and list the number of posts/day for a better sense of what’s going on and where we need to concentrate efforts to improve use of re…

대시보드 보고서 - 좋아요

커뮤니티 구축 데이터 및 보고

JammyDodger 1월 10, 2024, 12:04오전 2

이 쿼리에 AND pa.deleted_at IS NULL을 추가하여 Likes 캐스트를 필터링한 후 삭제된 항목을 제거해야 하는지, 아니면 대시보드 쿼리 자체를 수정해야 하는 가능한 변경 사항인지 궁금합니다.

글		댓글	조회수
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	223	12월 31, 2019
Dashboard Report - Reactions Data & reporting reactions , sql-query , dashboard-reports , dashboard-sql	2	557	1월 19, 2024
Dashboard Report - Top Users by Likes Received Data & reporting sql-query , dashboard-reports , dashboard-sql	0	332	2월 1, 2024
Dashboard Report - Top Users by Likes Received From a Variety of People Data & reporting sql-query , dashboard-reports , dashboard-sql	0	310	2월 1, 2024
Top 50 likers Data & reporting sql-query	0	185	2월 12, 2018

대시보드 보고서 - 좋아요

Related topics