I'm looking to have a variety of reports - tickets by first reply time bracket, first reply time (median), etc - and I'd like all of these reports to exclude tickets with the tag "aircall" as well as the time that the tickets were in the Pending or On-hold status.
The formulas I've tried to use either gives me separate bars on the same graph - one for tickets without the tag and the other for tickets that did not have the pending or on-hold status. Or, the tickets with the tag "aircall" are not actually being filtered out.
If anyone has any suggestions of what code snippet (or what configuration in the report) would allow me to accomplish this, I'd greatly appreciate it.
I recommend trying out the formula provided in the article to exclude pending and on-hold status, and then you can create a calculated attribute for filtering out tickets with "aircall" tags. Use the following formula:
After creating this attribute, add it as a filter in the report and select "True." This will effectively exclude all tickets that have "aircall" tags.