How to count issues within a time frame that has specific custom field value

[PJohansson]

Hi community!

I need to create a report for the last six months that shows number of tickets created per week that has a specific field value.

We have a custom field called “Type of incident” with three options “Application”, “Infrastructure” , and “Data”.

I want this report to show on a weekly basis how many tickets of each incident type has been created:

Week	Application incidents	Infrastructure incidents	Data incidents
Week 1	0	3	1
Week 2	2	1	0
etc

I haven’t been able to get these columns to show nor do I get how to make them a count rather than an individual value for each ticket.

Any help will be greatly appreciated!

[ilze.krauze]

Hi PJohansson,
Welcome back!

To show “Issues created” and other measures by “Type of incident” you need to import this field as a dimension.

Please check in the Source Data >> Edit >> Jira import options Custom fields if “Import as dimension” is selected for this field.

If it is already being imported as a dimension, then it should grouped under under “Custom fields” dimensions link:

Let me know if this works or if you have more questions!

Kindly,
Ilze