I have a model called member that has 6 columns: ID, Value1, Value2, Value3, Value4, Value5
The values in columns Value1, Value2, Value3, Value4, Value5 are either Y or N. I'm trying to query by ID to count the number of Y values for each member. For example one row would be: 5, Y, N, Y, N, N I would like to return: 2 (since that is the number of Y in that member's row) I've tried using Aggregate, Annotate, F, Q, Sum, Count in different ways and I'm missing the mark. I've been through the docs and SO for about 2 hours. I would post my errors but it's on my work computer and I have to post here from my personal laptop. I feel like I may be over-thinking it but I can't quite figure it out. Any help would be greatly appreciated. Jason -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/597a0acf-65a0-4e9a-8a9f-b61892860789n%40googlegroups.com.
