How to use select list values to compare if someone submit the tickets on weekly basis.

Question

Hi,

I need to generate a report based on how many Project managers submit their weekly report based on the project list.

I have a custom field named as Project Name with 10 projects listed and date field week ending date.

I want to pull a report which shows on particular weekending date, how many PM's didn't submit the report based on the project list.

E.g on weekending 1/4/2019,  if 3 Projects don't have tickets created then I should report those three project PM's to submit tickets.

Mangesh Rane_3vruud · Answer

Thanks for the reply, but I want to display only those projects which are not submitted for a particular weekend.

E.g  I have total 50 projects but only 20 projects submitted for weekend 1/11 , but I want to display remaining 30 project names those haven't submitted for weekend 1/11 yet.

Let me know, your thought.

Thanks

Fazila Ashraf · Answer

Hi @Mangesh Rane

Try using the jql => "project name" in (proj1, project2.. till project10) and created > 1/30/2018 and created < 1/5/2019

This is will all the tickets created in the given date range with the custom field set as one among the given list.

Then you can use the Issue statistics gadget to give you the issue count by project name custom field. If the project name doesnt make up to the data,  you can consider no tickets were created in the period