Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Custom reports help

Hello,

I am trying to make some Custom reports and struggling to have the desired results.

We have one Project in Service desk, and we have created Organizations for each client we have. We are filtering tickets in Queues with the help of Organization filter and Resolution filter with JQL.

Now, I want a report per organization for the number of open and closed tickets for a customer date range. Let's say;  Open Tickets of Organization A for last month.

Similarly; Close tickets of Organization B for last month.

 

Is this possible?

 

1 answer

0 votes
Liam Green Community Leader Nov 19, 2020

Hi @Hassaan Khan 

The below should assist with what you need

organization = "Organization A" AND created date >= StartofMonth("-1") AND created date <= EndofMonth("-1")

organization = "Organization B" AND resolved date >= StartofMonth("-1") AND resolved date <= EndofMonth("-1")

Let me know if that works

Regards, Liam

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

163 views 0 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you