Jump to content

Number of levels - category reporting

Dan Munns

Recommended Posts


Can we have an option when h_category is selected as a group by to limit the levels? 

I have a measure that shows all incident requests logged and a saved field is h_category so that I can create a chart to show the amount of each type of incident. 

The issue is we have so many categories due to the amount of teams it makes the report chart next to useless. 

I would like to be able to filter the categories to only show the first two levels at most but currently am unable to do this. 


As you can see the amount of categories is a little on the large side. This is filtered down to only show the IT teams at the moment (about 12 teams)

(Also, have a guess at what category is the green one...) 


Link to comment
Share on other sites

  • 2 weeks later...

@Victor I was thinking of being able to set the max level. So either just the top level, down two levels etc. 

The issue I have is the our categories are like this:

Incident > Software > Microsoft > Outlook

Now, I might care that we have x number of Outlook issues per month, but ExCo don't really need that level of detail and x number of software issues would be fine for them. 

To be able to limit the levels to x tiers deep per report would be very useful. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...