Shivani Darji Posted October 9, 2020 Share Posted October 9, 2020 Hello, I am new to this forumand trying to submit a question with same ple data (attached). I am trying to figure out a ratio of the % of times a ticket met the requested Turnaround Time (TAT). In our process the end user can submit a Requested TAT and the resolved Date signfiies when the ticket was marked complete. In column i have manually put if whether the requested TAT was met or not but how do i do this Spotfire 10. A column like column "E" does not exist so do we need to create one like that Either way i am looking for the most efficient way to obtain this ratio so that i can determinethe % of times our teamis able to meet the requested TAT. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted October 9, 2020 Share Posted October 9, 2020 Attached you will find one possible solution. I have added a calculated column for your criteria using the DateDiff function. Please check column properties for more details. Moreover I simply added a bar chart where the data is split with the 'color by' option on your criteria. And then set to a 100% stacked bar chart. But you can also find a cross table. There are so many ways to display/calculate this rate... Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now