How to Create report on "Minimum 1 problem ticket created per 200 incidents" for month.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2024 05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2024 06:22 AM
What exactly are you looking for? Your one-liner doesn't make sense. The number of Problems shouldn't be related to the number of Incidents, although more incidents would indicate a higher number of problems as well, but there is no way there is a 1-to-200 ratio (or any ratio) that exists.
How do you expect this to show? Why not just put two single scores on the dashboard to see the numbers?
You could try to do something with Performance Analytics to get a formula involved and show that number, but please, go back to who ever is asking this and tell them their requirement doesn't make sense.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark