Django ORM to remove unwanted groups by annotating multiple aggregated columns

I want to create a query like this in Django ORM.

SELECT COUNT(CASE WHEN myCondition THEN 1 ELSE NULL end) as numyear
FROM myTable

Below is the djang ORM query I wrote

year_case = Case(When(added_on__year = today.year, then=1), output_field=IntegerField())

qs = (ProfaneContent.objects
                    .annotate(numyear=Count(year_case))
                    .values('numyear'))

This is the query generated by the django orm.

SELECT COUNT(CASE WHEN "analyzer_profanecontent"."added_on" BETWEEN 2020-01-01 00:00:00+00:00 AND 2020-12-31 23:59:59.999999+00:00 THEN 1 ELSE NULL END) AS "numyear" FROM "analyzer_profanecontent" GROUP BY "analyzer_profanecontent"."id"

Everything else was fine, but django put a GROUP BY at the end , resulting in multiple lines and wrong answers. I don't want it at all. There's only one column right now, but I'll put more columns like this.

Edit based on comments I'm going to use the qs variable to get values ​​about how to sort in the current year, month, week.

UPDATE Based on the comments and answers I'm going to post here, let me clarify. I just want to do this on the database side (obviously using Django ORM instead of RAW SQL). It's a simple SQL query. Since the data can be too large, doing anything at the end of Python would be inefficient. That's why I want the database to give me the sum of the records based on the CASE condition. I'll add more such columns in the future, so things like len() or .count won't work.

I just want to create the above query using Django ORM (without GROUP BY appended automatically).