How to get year wise view on incident Report with respect to location?

[sahana1998]

How to get year wise view on incident Report with respect to location ? condition : incident created b/w 2021 to 2023

I was tried as below i could see how many incidents has been created as per year. but it is not showing as per location.

Can anyone help me on this?

[OlaN]

Okay, in your report, try to filter out incidents that are without Location data, and see if you get any results.

Like this:

[AndersBGS]

Hi @sahana1998 ,

I agree with @OlaN - The group by "location --> country" is not holding data for the tickets in the visualization. All incidents shown within the graph is showing as empty for country. Please revisit the dot-walked group by column on the cmn_location table. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders