I'm creating a budget application and wanted to find the sum of each user who's signed in. Right now, I'm using function-based views and I sum up the expenses with Post.objects.aggregate(sum = Sum('expense')) The issue with this is it sums up everyone in the database but I wanted it to only sum up the expenses of the user that is currently signed in. In my model, I have an author field but I'm not sure how to go about summing only for the user currently signed in.
You can do something like this to get current user expense
Post.objects.filter(author=request.user).aggregate(sum = Sum('expense'))
this will return sum of current logged In user.