Hi folks,
the application of my customer is showing service requests and their eradication. In concret the customer is getting a list each month of open requests. The requirement is to show a chart by month and how often service requests are still open.
When I have the service requests as dimension and the following formula in expression
=
class(count({<Dat1=>}Request),2)
I get the number of stays in the class.
I want the classes (how long requests stay open 1,2,3..) as dimension (the customer is only interested if the requests arises or are reduced month by month)
Is this possible on the surface? I know how to manage this on the script level (and then the class function in the dimension works as well). As I have not only the service request but other fields as well, I would like to avoid the work on script level
Any ideas?
