How can i add filters to a query based on action chains?

I have a query of reports in my database and I need to set 4 page variables : total number of reports, reports assigned to user, completed, completed today. I have created 4 page variables and I am getting list of reports using supabase backend query.

I want to set the 4 page variables using the a single backend by applying filters consecutively to available results.