Tip #36: Create efficient trend analysis Reports in Qntrl

Tip #36: Create efficient trend analysis Reports in Qntrl



Reports in Qntrl gives you an overview and monitors the important activities within the organization. With this feature, you will be able to have an insight over different information in a simple visual format, making it more relatable and efficient when it comes to taking business decisions. Apart from the Default Reports that Qntrl provides, Custom Reports help display the trend of a specific information long-term.
 

But, how?
  • You can capture the response to different tasks and hurdles, and try to improve the processes by identifying possible bottlenecks or hurdles that can help the business grow in the right direction.
  • You can improve or change strategies if the processes have been underperforming or stuck up for a while.
  • You can make informed decisions with the data available, acting as evidence to your decision-making.

Here’s how you can do it.
 
  1. This report shows the most commonly preferred way of marketing a campaign by the Marketing team, helping the organization choose a marketing tool based on the usage statistics.



  2. The report configuration and trend analysis is as shown below. Set the Y-axis as ‘Count’ & ‘Card’, and the Group By as ‘Assignee’.




  3. This report shows the trend of onboarded clients and their current status in the sales cycle, helping the organization understand the swiftness or deviation in the delay of the onboarding process, if any.

             


Set the Y-axis as ‘Count’ & ‘Card’, and the Group By as ‘Assignee’.

            

Some of the other instances where you can generate trend analysis reports are:
  • Checking if the employees have set the right priority of tasks when they work, based on client order flow.
  • Analyzing the campaign objective in the last 2 years to understand click through rate in the sales vs. educational campaigns.
  • Monitoring the employee’s monthly stats while handling Enterprise Customers’ escalations.
  • Comparing the conversion rates of the launched products, weekly. 
 
Before you go on to create these reports, here are some things to ensure that the business data is collected, recorded, reported, and evaluated efficiently.
 
  • Every data you wish to monitor in the Reports has to be a Dropdown/User Dropdown/Date/ Date&Time field in the card details page, or default Qntrl values (like Created time, Closed time, Stage, etc., in the X-axis) in order to maintain useable format of data.
  • When you analyze critical decision points like potential cash flow issues, staffing, peak sales periods, success of marketing campaigns, staff hours, stock (in or out) - ensure to collect information on a regular basis with the frequency determined by the type of data you are collecting. This ensures the participation of team/individuals so that they can regularly update the status of cards to collect and record data.
 
Try out and create trend analysis reports and explore unique ways to use them in your organization. Leave your comments below or email us at  support@qntrl.com



    Access your files securely from anywhere







                            Zoho Developer Community




                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts



                                                            • Sticky Posts

                                                            • Tip #21: Increase user engagement using dynamic email content and attachments in Orchestly

                                                              Businesses often send out bulk emails like weekly newsletters, monthly event updates, promotional emails, surveys, beta access emails, product reviews, seasonal greetings, and so on. Even as the gist of these emails remain constant for all recipients, personalizations capture the audience’s attention and help brands connect with them.   Orchestly’s email templates allows you to draft and send dynamic emails with personalized content and attachments to internal and external users. Email templates
                                                            • Qntrl's 2023 year in review

                                                              This year has been all about analyzing our customer feedback and building a resilient and solution-driven product from it. As a result of this work, we're happy to announce that a whole new version of Qntrl is getting ready for release soon. This new
                                                            • Tip #61: 5 different ways to create Cards in Qntrl

                                                              Qntrl supports an array of features that covers everything required for business orchestration, from process automation to business advancement. Cards, being the elemental feature of Qntrl, record all the details of a particular task from the beginning
                                                            • Tip #17: Stay informed of significant business impact using Orchestly

                                                              With remote working becoming the new norm, leaders across sectors need to stay updated of their business performance in the market to aid business decisions. Instead of awaiting virtual meetings from sales and finance heads to put forth the business status, organization leaders can themselves dig into the system to keep an eye on their revenue generating customers or set up notifications to monitor major updates.   Orchestly recognizes such requirements and provides adaptable solutions for all business
                                                            • Onboard faster with Orchestly's Tutorials

                                                              We are actively rolling out new learning materials to assist our customers onboard at ease and automate their processes effortlessly. On that front, we recently launched Tutorials for Orchestly.   Tutorial is a step-by-step guide to help users familiarize the concepts of Orchestly and automate simple processes right from scratch. We’ve documented 3 such business processes viz. Order Manufacturing, Product Implementation, and Change Management.   We're looking forward to document more customer-centric


                                                            Manage your brands on social media



                                                                  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

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner









                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Workdrive Oauth2 Token Isn't Refreshing

                                                                                                                I have set up oauth for a bunch of zoho apis and have never had a problem with oauth. With workdrive i am using the exact same template i usually use for the other zoho apps and it is not working. All requests will work for the first hour then stops so
                                                                                                              • Single Portal for Multiple Apps

                                                                                                                Hello, I'm just getting started with Zoho and I'm very overwhelmed. I am currently using the free trial of Zoho One, but if I can figure it out, I intend to upgrade to the paid version. Zoho One, of course, gives me  access to an entire suite of services/applications. One of the things I'd like to do is have a single place for clients (customers?) to log in and view current projects, invoices, contact information, etc. A single login for my clients. A single portal. I've come across documentation
                                                                                                              • 【開催報告】 大阪 ユーザー交流会 2025/11/20(木)Zoho CRM Plus 活用のアイデアとデータの“見える化”

                                                                                                                皆さま、こんにちは。コミュニティチームの中野です。 11/20(木)に、大阪 ユーザー交流会を開催しました。本投稿では、その様子をお届けします。 当日の登壇資料などもこちらに共有しますので、参加できなかった皆さまもご参照ください。 (Zoho 社員セッションの登壇資料については、11/28(金)に開催予定の東京回の開催報告で共有いたします) 今年2回目の開催となる大阪 ユーザー交流会では、株式会社KDDIウェブコミュニケーションズ 山田さんによる Zoho CRM Plus の事例セッションのほか、「Zoho
                                                                                                              • Every rating counts: Shaping customer experience

                                                                                                                We are back to that beautiful time of the year. It is the season to reflect, be thankful, and appreciate everything that has happened throughout the year. Thanksgiving is a time we connect with our family, friends, and relatives to strengthen relationships,
                                                                                                              • How to remove duplicate contacts

                                                                                                              • Custom Field for Subscription

                                                                                                                Hi, I can't find a way to add a custom field (to contain a license key generated from our software) against a subscription? Is the only place to add this information in the Invoice module (as custom field for invoice)? When a customer views his subscription via the customer portal, there appears no way to display a license key for them? The invoice is not the natural place to store a license key for a particular subscription, so where else can this be stored and displayed?
                                                                                                              • Custom View and Custom Fields on Zoho Books

                                                                                                                Hi, I have some custom fields on Estimates and Invoices. I also use Custom Views so I can have a lot of information at a glance. I want to include my custom fields as columns in my custom views of estimates / invoice, but it looks like is not possible.
                                                                                                              • Dropdown data depends on filters in another field.

                                                                                                                In my quote form I have a lookup field called Reseller that pulls from Accounts. I would like it to pull from Accounts, but only those accounts with an account field 'Type' where that is 'Reseller'. Does anyone know a way to do this? Similarly, I'd like
                                                                                                              • Is it possible to adjust the web browser tab title (when a ZoHo Desk ticket is opened)

                                                                                                                Hi All, When I open a ZoHo Desk ticket in a web browser, the tab title (text that appears at the top of the browser tab) uses the logic: *company icon picture* (xxxx) #ticket number - company name See below (highlighted in red) for reference. Company
                                                                                                              • Collections Management: #7 Common Mistakes during Payment Collection

                                                                                                                Payment collection may appear straightforward in most cases. Still, as your customer base expands and transaction volume increases, it becomes clear that even small inefficiencies can lead to delayed payments, increased support load, or even revenue loss.
                                                                                                              • Rename Record Summary PDF in SendMail task

                                                                                                                So I've been tasked with renaming a record summary PDF to be sent as part of a sendmail task. Normally I would offer the manual solution, a user exports the PDF and uploads it to a file upload field, however this is not acceptable to the client in this
                                                                                                              • Text/SMS With Zoho Desk

                                                                                                                Hi Guys- Considering using SMS to get faster responses from customers that we are helping.  Have a bunch of questions; 1) Which provider is better ClickaTell or Screen Magic.  Screen Magic seems easier to setup, but appears to be 2x as expensive for United States.  I cannot find the sender id for Clickatell to even complete the configuration. 2) Can customer's reply to text messages?  If so are responses linked back to the zoho ticket?  If not, how are you handling this, a simple "DO NOT REPLY" as
                                                                                                              • Custom Field in Zoho Projects pulling into Analytics

                                                                                                                We have a client that we have built our their new business process using Zoho Projects, and we have build a lot of custom fields with their their Projects where they are capturing specific data points that we want to be able to track and pull data, as
                                                                                                              • Marketer's Space - Holiday season email marketing tips you should know

                                                                                                                Hello Marketers! Welcome back to another post in Marketer's Space! 'Tis the season—that time of the year everyone eagerly anticipates. While most look forward to relaxing, marketers will be super-busy from late November to early January. Mistakes can
                                                                                                              • Zia Competitor Alerts made easy with Zia's suggestions

                                                                                                                Hi everyone, In addition to the existing manually added competitors, Zia will now find your competitors for you - instantly. Earlier, you had to identify competitors through research manually, support tickets, or tradeshows—a time-consuming process that
                                                                                                              • Add Custom Field Inside Parts Section

                                                                                                                How to Add Custom Field Inside Parts Section in Workorder like Category and Sub- Category
                                                                                                              • Zoho CRM Community Digest October 2025 | Part 2

                                                                                                                Hello Everyone! From new mobile capabilities and smarter integrations to real-world workflow fixes and developer insights, all the highlights from the second half of October is covered right here. Let’s dive in. Product Updates: Zoho CRM Mobile Updates:
                                                                                                              • Understanding Zoho Contracts

                                                                                                                Effective contract management relies on systems that are structured, organized, and reliable. Every feature, workflow, rule, and restriction in Zoho Contracts are designed the way they are to ensure consistency, compliance, and control across every stage
                                                                                                              • Tip of the Week #76– Automate your inbox during vacation in Zoho TeamInbox

                                                                                                                When you're on vacation or away from your desk, the last thing you want is for important emails to be missed or left unanswered. The good news is, you can easily set up rules in Zoho TeamInbox to assign incoming messages automatically to a teammate who's
                                                                                                              • Domain restriction for User Management actions in Zoho One

                                                                                                                Greetings, Zoho One Admins! To strengthen account security further and safeguard user management settings, we are imposing domain-based restrictions for user account-focused admin actions in Zoho One. In addition to password reset of user, organization
                                                                                                              • Zoho Mail iOS app update: Signature

                                                                                                                Hello everyone! In the latest version(3.1.7) of the Zoho Mail app update, we have brought in support to create, edit and remove signature within the app. You can create signature from the compose screen as well as from within the Settings module(inside
                                                                                                              • Desktop app doesn't support notecards created on Android

                                                                                                                Hi, Does anybody have same problem? Some of last notecards created on Android app (v. 6.6) doesn't show in desktop app (v. 3.5.5). I see these note cards but whith they appear with exclamation mark in yellow triangle (see screenshot) and when I try to
                                                                                                              • Approval Button in Subform

                                                                                                                Hi Team, I’m working on a subform-based requirement where users will submit requests, and these requests must go through approval by multiple team managers. Each line item in the subform needs to be individually approved or declined based on the user's
                                                                                                              • Setting checkbox value on template in Sign from Creator

                                                                                                                Good day, Please help me understand how do I set a tick from a checkbox in Creator into a checkbox on a Sign template. Below is the only values on the Sign template and the code from Creator, "field_boolean_data": {}, "field_date_data": {}, "field_radio_data":
                                                                                                              • Zoho Projects - Unread Comment Icon

                                                                                                                Hi Projects Team, It would be great if there was a notification I con on the comments icon so it's easy to see which tasks have new comments. Something like a red circle with a number of unread comments would be great. Thanks for considering my feed
                                                                                                              • Zoho Projects - Update Feed via API

                                                                                                                Hi Projects Team, Please consider adding an API to allow update and retrieval of messages to the Feed. Thank you
                                                                                                              • Automated log-out/session end

                                                                                                                I'm concerned about security of our data. Is it possible to set an automatic time-out for user sessions on Zoho CRM, after a certain period of inactivity or when the session reaches a certain duration (12 hours perhaps)? 
                                                                                                              • Subform auto populate values

                                                                                                                Hi Team, I’m trying to retrieve values from Zoho People using API functions and dynamically populate them into a subform. For example, I’ve created a form with several fields that users will fill out. Based on their input, I need to fetch records from
                                                                                                              • What is New in CRM Functions?

                                                                                                                What is New in CRM Functions? Hello everyone! We're delighted to share that Functions in Zoho CRM have had a few upgrades that would happen in phases. Phase 1 An all new built-in editor for better user experience and ease of use. ETA: In a couple of days.
                                                                                                              • Gantt Chart - Zoho Analytics

                                                                                                                Are there any plans to add Gantt Charts capabilities to Zoho Analytics?
                                                                                                              • WhatsApp Calling Integration via Zoho Desk

                                                                                                                Dear Zoho Desk Team, I would like to request a feature that allows users to call WhatsApp numbers directly via Zoho Desk. This integration would enable sending and receiving calls to and from WhatsApp numbers over the internet, without the need for traditional
                                                                                                              • Identify long running sync jobs/tables

                                                                                                                My sync process causes strain on my production database and I'd love some tools/alerts to help me identify which tables are taking the longest. The current screen only shows 3 tables at a time and truncates the last fetch time so that it is very cumbersome
                                                                                                              • Temporarily rate limited due to IP reputation.

                                                                                                                We have suddenly started receiving the following Mail Delivery Status Notification: Diagnostic-Code: 4.7.650 The mail server [136.143.184.12] has been temporarily rate limited due to IP reputation. For e-mail delivery information, see https://aka.ms/postmaster
                                                                                                              • Associate emails from both primary and secondary contacts to deal

                                                                                                                We need to associate emails from multiple contacts to a deal. Please advise how this can be achieved. At present, only emails from primary contacts can be associated. Thanks
                                                                                                              • New integration: Zoho Sign for Zoho Projects

                                                                                                                Hey there! We’re excited to announce the brand-new Zoho Sign integration for Zoho Projects! With this integration, users can now send documents for signatures, track their progress, and manage approvals—all without leaving Zoho Projects. This bridges
                                                                                                              • Update to attachment display in ticket threads

                                                                                                                This enhancement will provide faster access for support teams and end-users, significantly boosting productivity for everyone. Get ready for a more efficient and satisfying experience! Immediate benefits Faster ticket rendering reduces wait times and
                                                                                                              • Narrative 15: Blueprint - Automate, guide, and transform your support processes

                                                                                                                Behind the scenes of a successful ticketing system: BTS Series Narrative 15: Blueprint - Automate, guide, and transform your support processes Even organizations that deliver quality products and services can face low customer satisfaction when their
                                                                                                              • Different MRP / Pricing for same product but different batches

                                                                                                                We often face the following situations where MRP of a particular product changes on every purchase and hence we have to charge the customer accordingly. This can't be solved by Batch tracking as of now so far as I understand Zoho. How do you manage it as of now? 
                                                                                                              • ZOHO BOOKS - RECEIVING MORE ITEMS THAN ORDERED

                                                                                                                Hello, When trying to enter a vendor's bill that contains items with bigger quantity than ordered in the PO (it happens quite often) - The system would not let us save the bill and show this error: "Quantity recorded cannot be more than quantity ordered." 
                                                                                                              • Refresh frequency

                                                                                                                Dear Zoho Team, I really, truly appreciate that Zoho Books gets frequent updates. As a matter of fact this is how a good SaaS company should stay on top. However, I feel that I have to hit refresh almost every day. This was exciting at the beginning but
                                                                                                              • Next Page