Trabalhando na consulta da visualização total de uma categoria

Suporte
1

So we’re wanting to measure the number of views a specific category gets and so I have done a query for it:

SELECT date_part('month', created_at) as Mth, 
     sum(views) as FAQViews 
FROM topics 
WHERE category_id = '11' 
GROUP BY Mth

and its returning values grouped by the month, but the values are like 1/100th what the category listing shows… Not sure what I am missing here

2

Looks more or less right except that you are not including year and you are including deleted content. Maybe your category_id is wrong…

3

Yeah - had the wrong category and need to also ignore deleted