You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
We are trying to give more attention to new customers that have opened a limited number of support tickets. To do this we'd like to create a JQL query (ideally informing a report), based on customers that are under a certain threshold old that have opened a certain number of tickets. Is it possible to write a query that looks up the age of certain values (such as organization)? The query would ideally return the number of customers that are X (or less) days old with Y (or less) number of submitted tickets.
If this isn't possible based on the customer organization field, does anyone have any suggestions on how to accomplish something similiar?
Hi @James K_
To my knowledge, the date of customer organization creation is not somewhere accessible to us (if stored anywhere). In addition to that, JQL searches for issues and other fields related to issues. The date to which an organization is created is not stored on an issue. Therefore you couldn't write any JQL to bring the customers. JQL yields only issues results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.