Custom Reports using the Request Form fields

[Banajyotsna palbabu]

Hi,

One of our issue type has two request forms associated to it. One of the request form tracks the Dept of the user who created the issue. I would like to create a report to see which Dept created the maximum number of tickets. I could not achieve it through Queues or the standard reports available. Can you please elaborate a bit ?

Thanks in advance

Jyotsna

[Brant Schroeder · Accepted solution]

@Banajyotsna palbabu If you are stating that your Issue Type has two Request Types associated with it then you can create a filter and filter on Request Type.  You will have to use advanced search but it would look something like this project = PR and "Request Type" = "Get IT help (PR)" You can also do this in the queues. 

[Banajyotsna palbabu]

Thank you @Brant Schroeder . I used the advance Search to filter it out based on Request Type. Still I am not able to add the Department Column to add as an option which is a field in the Request form associated to that Request Type. What am I missing here ? 

Thanks

Jyotsna 

[Brant Schroeder]

@Banajyotsna palbabu If you are using the new forms functionality fields on the form will only be searchable if they are linked to a field on the request (delivered or custom field)  https://support.atlassian.com/jira-service-management-cloud/docs/link-a-form-field-to-a-jira-field/

[Banajyotsna palbabu]

Thank you so much. I figured that as well, it has to be linked to a Jira field.