I am developing a cohort analysis in Zoho Analytics for Tickets/Service Desk, which tracks the number of tickets created each month and when those tickets were closed. I have added a user filter for classification. When I change the classification using the filter, the count of closed tickets updates accordingly. However, the counts for open and pending tickets do not update based on the selected classification.
I have created a query table to count the total tickets and pending tickets.