I wanna know how I can create a measure in CA BUSINESS INTELLIGENCE powered by TIBCO Jaspersoft that can calculate the number of days from the SLA expiration date to the current date. If a Service Desk ticket closing date as been passed and the ticket is still not closed and have violated the SLA.
I also want to add this into columns so it can be viewable in reports as well.
Please guide me looking forward for help as soon as possible.
Want to calculate time span after the ticket SLA expires.
in Products
Posted
Hello Team,
I wanna know how I can create a measure in CA BUSINESS INTELLIGENCE powered by TIBCO Jaspersoft that can calculate the number of days from the SLA expiration date to the current date. If a Service Desk ticket closing date as been passed and the ticket is still not closed and have violated the SLA.
I also want to add this into columns so it can be viewable in reports as well.
Please guide me looking forward for help as soon as possible.
Regards,
Omair