Gail

Yes, that helped! And, I realized that I actually needed to follow Gab's instructions to create an attribute instead of metric. So, for others on here - if you're trying to create a query that hides tickets with the 'closed_by_merge' tag, you'll want to create an attribute vs. a metric using Gab Guinto's code. In my case, my primary filter was D_Count for all of my tickets, and then one of my rows was the closed by merge attribute. I then filtered that row to only return "not merged." Hope that helps others who got a little lost like me!

Carl McDowell - I am confused by steps 7 & 8. Do you mean to change the name I just created (Exclude closed by merge tickets) to D_Count? Or, are you saying that I should replace D_Count with what I just did? When I created a query with the calculation I just created (instead of D_Count), my results included closed by merge tickets. And, the solution that Joshua offered was not available to me. Could you please further explain the final steps?

Pablo Kenney, I also need this capability - thank you.

Charlotte and Carol - did you ever get a solution to this issue? We need the ability to require someone to answer yes to a dropdown (or be required to check a checkbox), but because the default is '-', they can submit without choosing 'yes' even though it's the only answer.

Hello - what if I wanted to have a pre-filled subject that also included the date/time of the end user opening the form URL - something like:

&tf_subject=Complaint YYYY.MM.DD

Is there a way to do this? thanks!