How to Calculate MTTR (Mean Time to Resolve)
We want to calculate MTTR (Mean Time to Resolve) in our Zoho Analytics report under Tickets. Currently, we are using the following fields:
-
Ticket ID
-
Ticket Created Time
-
Ticket Closed Time
-
Ticket On Hold Time
We are planning to calculate MTTR (in days) using the formula:
MTTR = (Ticket Closed Time – Ticket Created Time) – Time spent in ‘On Hold’ – Time spent in ‘Awaiting Customer Info’ – Time spent in ‘Customer Pending Testing’ – Weekends
Could you please confirm which fields are actually necessary for an accurate MTTR calculation?
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Sandeep Choudhary
Anitha Rajesh Kumar
Sticky Posts
What’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expandedAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.Invitation-Based User Access in Zoho Analytics
Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve securityZoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience
Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you[Webinar] Evolving BI & Analytics in the Age of AI
Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Caldav Synchronizer shows error System.Xml.XmlException: Root element is missing
We are using Outlook 2019 and CalDav Synchronizer to sync our calendars. Since ~two weeks we are not able to sync anymore, we always get the Error System.Xml.XmlException: Root element is missing I attached a screenshot with the full error message. System.Xml.XmlException:What is the module name for "Vendors" in a call to info zoho.books.getRecordsByID?
What is the module name for "Vendors" in a call to info zoho.books.getRecordsByID? "vendors" is incorrect. zoho.books.getRecordsByID("vendors", books_organization_ID, vendor_id, "books_full_access");How to set the width of the columns in a script
Dear community, hope you all are doing great, I'm creating this thread to check the following: I have a deluge script that creates a PDF file with a table and I'm strugling to set the width of the columns. Here's the snippet of my code which creates thisAny idea for loading animation workaround?
On my application i have page with ZML <image> which has attribute action='Function'. when the image (icon) pressed a function get called and sometimes the function takes some time (API Calls). For making a reasonable UX i would like to show a signGenerate Payment Link - ZOHO Books by an API
Hello Team, is there any way we can Generate a Payment Link - ZOHO Books by an API, if anyone has any idea about this please do comment? Thanks & Regards Piyush GoyalEmail hook is triggered twice for a single email
I have a problem with Zoho Flow. Started yesterday. Every incoming email is processed twice by the same flow, but there is only one entry in the history. On the dashboard I can see that the flow was executed 6 times (3 emails received) and I have 3 entriesOpportunity Reappears in Pipeline After Exiting Blueprint – Need to Prevent This
An opportunity reappears in the Pipeline after exiting the Blueprint, and the user is able to move it — I don't want this to happen. Can someone help me?"Fetch a task by ID
Hi there, is there an option to fetch "Zoho Project " task by ID in "Zoho Flow" or any really way to fetch task currently. Thanks in advancePerfomance Management - Zoho People
Hi team, I am looking for performance management data such as KRA, goals, feedback, appraisals, etc., in Zoho Analytics. However, I am unable to find these metrics while editing the setup. Could you please confirm whether these fields are available inZoho CRM Canvas is slow in loading
Hi, the new Canvas feature in Zoho CRM is very interesting but the layout becomes very slow to load. I mean using the standard layout for Contacts detail view takes about 2,200 ms to completely load the page on my Chromebook (and my connection speed isWhat's New in Zoho Books - June 2024
Hello users, We are back with new features and improvements to enhance your accounting experience in Zoho Books. Keep reading to discover what's new in Zoho Books this June. Generate ABA Files for Bills [Australia Edition] An ABA file (Australian bankingWhat's New in Zoho Books - May 2024
Hello users, We've rolled out new features and enhancements to elevate your accounting experience in Zoho Books. Dive in to discover what's new in Zoho Books this May. Alipay Payment Method for Stripe Alipay, a popular digital wallet in China, is nowAnnoying Pop-Up Zoho Advertisements and Announcements Within Apps
It is beyond frustrating to have to close out Zoho's announcements for Webinars, Zoholics, updates, events, etc while working within ANY of the Zoho apps. I see it when accessing Zoho One, Cliq, Creator, and CRM. Zoho boasts to be a professional solutionLinking fields from different modules
is it possible to have fields from 2 different modules linked together? For example, within our opportunity module we have an account field. Can we create a new module that is linked to the opportunity module with the account field? So when the account field is updated in the opportunity module, it also gets updated in the new module?Detect previously signed PDF in package
When you include a previously signed PDF document in a package, if that document had text tags in it, Zoho Sign will add new signature fields on top of the real signatures. That should be a disfavored action for two reasons: (1) it's almost never goingBoost your productivity :: Scheduled Time Log Reports
Hello Everyone, In this series of power of Automation, I would like to highlight a handy automation feature designed to make our life easier - Schedule export for time logs. With this feature, we can automate the export and delivery of timesheet reportsMy mobile phone marked as spam
Hi there, I attempted to add my mobile phone, from Canada, to the settings under my Zoho vault account. An alert came up saying it is marked as spam when it is definitely not spam. What do you suggest I do next? Thanks so much!Tip #5: Setting access rights at the subfolder level
Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!
Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementallyAutomatically charge tax on shipping
When we do a quote we charge tax on the subtotal cost, but when I put in shipping I have to manually select a tax amount. How do I have it automatically apply tax to the shipping as well? I have provided a screenshot that shows I have to manually do this.What's New in Zoho Books - July 2024
Hello users, We are back with a bunch of new features and enhancements this month to make your accounting experience seamless. Keep reading to learn more about them. Explore An Enhanced Reports Module We've streamlined the Reports page to increase efficiencyClient Script - getBlueprintTransitions returns array of empty objects
Just like the title says, when I'm getting the Blueprint transitions via client script, the function returns an array of empty objects. It does correctly get the number of blueprint transitions on the page, however all the objects are completely empty.merge the Multiple POs to single PO if Vendor of PO"s --in Zoho Inventory
HI Merge the Multiple POs to single PO if Vendor of PO"s are Same ----in Zoho inventory Please provide any work around to achive this .ZOHO Blueprint and Workflow
Hi, Correct me if i'm wrong, Blueprint triggers when a record that meets the criteria is created. It follows a specific transition that you will be setting up. Does blueprint work if the first state was triggered by a workflow? For example, In my custom module 1, I have a field named status. The statuses are 1, 2, 3 and 4. As soon as I create a new record, a workflow triggers that updates the status field to 1. Can a blueprint start from 2? My other concern is, can blueprint transitions work at theHelp Updating form
I have a visitor management app, the visitor checks themself in at reception. Admin can see a report of all visitors onsite. When the visitor leaves, another form is used by the employee they are visiting to confirm they have left site. How can I makeHow to find (total) profits per item in Zoho inventory or Zoho Books
Hi, I would like to find out how to generate a report that has Item/ Cost Price/Sales Price (total)/Profit (total)/Margin The current sales reports has the total qty sold and the sales price but does not show the profits. Can i check how to do it? SimilarHow to create a not payed yet transaction for a vendor
I want to create a transaction for a vendor, similarly as I do it for customers, but I can't do it. Basically, I receive an invoice from a vendor, I want to register it as not paid, being able to mark them then as approved, and when the due date arrives,Workdrive Data Template & Viewing Document
Hello! Dipping my toe in Data Templates so I can better "tag" client files and assign properties for workflow, file renaming, automated filing/forwarding, and searching. (and other) I have a couple of Data Templated created and see where I can assignLinkedIn posting Admin
Zoho will not publish my posts to LinkedIn claiming I am not an admin on the page, but I am a super admin on the page. It makes no sense.Uploaded Videos not processing
We are unable to attach videos. When the file is uploaded, it gets stuck at 100% and the ATTACH button is not clickable. My assistant in the Philippines experienced the same issue. I am in California.Item Search
Hi there, any plans to enhance the item search function, to include searching also the item description, when doing estimates and invoices? Thanks![UI Update] Mandating New UI for all Zoho Analytics Users
Dear Users, We’re pleased to share that the new and improved Zoho Analytics 6.0 user interface has already been embraced by many users, delivering a faster, cleaner, and more efficient experience. For the Zoho Analytics users who are still using the oldButton Deluge not working
Please let me know if I need to post this somewhere else - this is my first time using the forums. I am attempting to build a button with a function that uses a multi-select lookup to build a list of interested buyers for properties based on the zip codeAutomate PAYMENT RECEIVED email
In BOOKS - how do I make it automatically send a Payment Received, Thank you email to my Customer when I match a transaction to an Invoice (thereby making it PAID)? Thank you for your help.maximum limitation of COQL API
from this documentation it said: You can retrieve a maximum of 1,00,000 records in multiple API calls per unique criteria. f you want to retrieve more than 1,00,000 records, use the Bulk Read API. my questions are 1. what is per unique criteria here?File upload in Workdrive
I am trying to get all the files and folders from dropbox to Workdrive with same folder structure. Can someone help me with which actions should I choose?I want to create an assessment with a value being greater than other value
I’m building an assessment form in Zoho Forms that includes multiple sections (or categories), each with 4 dropdown questions. Each answer is assigned a numerical value (from 1 to 5), and I use formula fields to calculate a total score per category. MyPost announcement / message on home or dashboard screen
I would like to post company announcements/messages on the Home Screen of our users. What is the best way to do this?Can you sync CRM contacts to TeamInbox?
Can you sync CRM contacts to TeamInbox? Or at least upload them? From what I can see, you have to enter them manually one at a time.Displaying Notes/Description Columns in "All Expense" showing Tabs
It's surprising to see there is no option to view description columns in tab showing all expenses. There are provisions for Reference# and Status, but why not the description/notes. Please Add. Thank You.Next Page