Explore Report Count tickets which where created before custom field date | Community
Skip to main content

Explore Report Count tickets which where created before custom field date

  • July 28, 2022
  • 1 reply
  • 0 views

Hi all,

we have a custom field "End of Warranty" where over a custom app the end of warranty of the product is written. I now want to count the tickets in Zendesk Explore where the creation date of the ticket was before the "End of Warranty". I cam up with this custom Attrbibute:

 

DATE_LESS_OR_EQUAL([Ticket created - Date],[Warranty End])

and as Metric I used Count(tickets)

But the tickets which where provided doesn't even had the custom field filled. 

Does anyone has an idea?

1 reply

Alex89
  • August 9, 2022
Hey Philipp,
 
Thanks for the post, I'm not sure I completely follow what you are describing when you say that "But the tickets which where provided doesn't even had the custom field filled" do you think you can post a screenshot of what you are referring to so I can get a better idea?
 
Best regards,