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’.




  2. 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 . 





      • 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

        • Recent Topics

        • String handling

          If I cut a currency string from a quote and try and paste it into the Deal "Amount", it will fail unless I manually delete any commas. Dollar signs are no problem, but comma's seem to fail. Please correct this Input Validation error.

        • email address somehow still not verified (?!)

          L.S. After creating a new email template in CRM I was about to send a group email to my clients, then Zoho CRM announced that they would change the sender address to some kind of Zoho-e-ddress because my email address "has not been verified". Not only

        • What's new in Zoho Sheet: Simplify data entry and collaboration

          Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally

        • WebDAV / FTP / SFTP protocols for syncing

          I believe the Zoho for Desktop app is built using a proprietary protocol. For the growing number of people using services such as odrive to sync multiple accounts from various providers (Google, Dropbox, Box, OneDrive, etc.) it would be really helpful

        • Consolidated report for multi-organisation

          I'm hoping to see this feature to be available but couldn't locate in anywhere in the trial version. Is this supported? The main aim to go to ERP is to have visibility of the multi-organisation in once place. I'm hopeful for this.

        • Feature Request - Allow Customers To Pick Meeting Duration

          Hi Bookings Team, It would be great if there was an option to allow customers to pick a duration based on a max and minimum amount of time defined by me and in increments defined by me. For example, I have some slots which are available for customers

        • Error Logs / Failure logs for Client Scripts Functions

          Hi Team, While we are implementing client scripts for the automation, it is working fine in few accounts but not working for others. So, it would be great if we can have error Logs for client scripts also just like custom functions. Is there any way that

        • Welcome to the Zoho ERP Community Forum

          Hello everyone, We are thrilled to launch Zoho ERP (India edition), a software to manage your business operations from end to end. We’ve created this community forum as a space for you to ask questions, comment answers, provide feedback, and share your

        • Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

          Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these

        • YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

          YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

        • Feature Request - A Way To Search Item Groups

          Hi Inventory Team, I can't find any way to filter or search by fields of Item Groups. It would be great to see that functionality added. I have a use case where a single product might come from 5 or more suppliers and each supplier's item is an Item in

        • Feature Reqeust - Include MPN In Selectable FIelds

          I have noticed that the MPN is not available to show in the list view of Items. Please consider adding it as EAN, UPC and ISBN are all available, so it doesn't make much sense to exclude this similar option. Thanks for considering my feedback.

        • Feature Request - Option To Hide Default System Fields on Items

          Hi Zoho Inventory Team, As far as I know it is not possible to hid some of the defult system fields on Items, such as UPC, MPN, EAN, ISBN. A good use case is that in many cases ISBN is not relevant and it would be an improved user experience if we could

        • Making an email campaign into a Template

          I used a Zoho Campaign Template to create an email. Now I want to use this email and make it a new template, but this seems to be not possible. Am I missing something?

        • Campaigns does not work!

          I am running into so many problems trying to use Zoho Campaigns, that I am seriously considering dropping the app from my (shrinking) list of Zoho applications I actually use. Apart from having to fight the software trying to create a design and email,

        • Feature Request - Make Available "Alias Name" Field In Item List View

          Hi Zoho Inventory Team, I have noticed that the "Alias Name" field does not appear on the list of selectable columns in the Customise Columns feature in the Items module. This would be very useful to see for businesses who are using the Alias Name field

        • Marketing Automation

          L.S. Marketing Automation is and has always been part of the Zoho One bundle - according to the information provided on the Zoho Website. Why when I open Marketing Automation do I get the following message?: "Your trial has expired. We hope you enjoyed

        • Cliq iOS can't see shared screen

          Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards

        • Bigin, more powerful than ever on iOS 26, iPadOS 26, macOS Tahoe, and watchOS 26.

          Hot on the heels of Apple’s latest OS updates, we’ve rolled out several enhancements and features designed to help you get the most from your Apple devices. Enjoy a refined user experience with smoother navigation and a more content-focused Liquid Glass

        • Notes badge as a quick action in the list view

          Hello all, We are introducing the Notes badge in the list view of all modules as a quick action you can perform for each record, in addition to the existing Activity badge. With this enhancement, users will have quick visibility into the notes associated

        • Claude + MCP Server + Zoho CRM Integration – AI-Powered Sales Automation

          Hello Zoho Community 👋 I’m excited to share a recent integration we’ve worked on at OfficehubTech: ✅ Claude + MCP Server + Zoho CRM This integration connects Zoho CRM with Claude AI through our custom MCP Server, enabling intelligent AI-driven responses

        • Automatic Matching from Bank Statements / Feeds

          Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these

        • How to filter Packages in zoho inventory api

          Hi Team, I want to perform some tasks in a schedular on the packages which are in "Shipped" state. I tried to use filter_by in my api call but in return I get response as {"code":-1,"message":"Given filter is not configured"} My Api request is as follows

        • CRM

          Is anyone else experiencing this issue? Our company is not moving out of using Gmail's web app. It just has more features and is a better email program than Zoho Mail. Gmail has an extension (Zoho CRM for Gmail) that we're using but we've found some serious

        • Automate pushing Zoho CRM backups into Zoho WorkDrive

          Through our Zoho One subscription we have both Zoho CRM and Zoho WorkDrive. We have regular backups setup in Zoho CRM. Once the backup is created, we are notified. Since we want to keep these backups for more than 7 days, we manually download them. They

        • Syncing with Google calendar, Tasks and Events

          Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning

        • IMAP mail after specify date

          Hi My customer's mail server is on premise and mail storage is very huge. So It never finish sync. and finally stop sync. Cloud CRM have a option like zoho mail sync mail after some date.

        • How can i view "Child" Accounts?

          It can be very useful in our field of business to know the parent-child account relationship. However, there seems to be a shortcoming in the parent account view: no child account list. How can we view the child accounts per each account?

        • Ability to assign Invoice Ownership through Deluge in FSM

          Hi, As part of our process, when a service appointment is completed, we automated the creation of the invoice based on a specific business logic using Deluge. When we do that, the "Owner" of the invoice in Zoho FSM is defaulted to the SuperAdmin. This

        • Easily perform calculations using dates with the new DATEDIF function

          Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

        • Adding Comments Using Workflows - How to Change User Attributed

          We have worklflows in Desk where a comment is added to a ticket based on certain criteria. It seems that the comment added is always attributed to the user who last edited the workflow. This does not make sense for us because: - It's misleading to other

        • Add Attachment Support to Zoho Flow Mailhook / Email Trigger Module

          Dear Zoho Support Team, We hope you are well. We would like to kindly request a feature enhancement for the Mailhook module in Zoho Flow. Currently, the email trigger in Zoho Flow provides access to the message body, subject, from address, and to address,

        • Conect chat of salesiq with zoho cliq

          Is there any way to answer from zoho cliq  the chat of salesiq initiated by customers?

        • Les dernières avancées en saisie de données et collaboration

          Après une année dédiée à la recherche et au développement, notre équipe est prête à dévoiler des améliorations majeures pour Zoho Sheet. Ces nouveautés seront lancées par étapes afin d’en assurer une prise en main optimale. Nous commençons avec des fonctionnalités

        • Deluge Learning Series – Client functions in Deluge | January 2026

          We’re excited to kick-start the first session of the 2026 Deluge Learning Series (DLS) with Client functions in Deluge. For those who are new to DLS, here’s a quick overview of what the series is all about: The Deluge Learning Series takes place on the

        • Rich Text For Notes in Zoho CRM

          Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By using

        • display call description in the notes section of a contact or add notes field to completed call screen

          When completing a call, we type in the result of the call in the description. However, that does not show up under the notes history on the contact. We want to be able to see all the calls that have taken place for a contact wihtout having to go into each completed call. The other option is to add the notes field to the completed call screen.

        • Implement Meeting Polls in Zoho Bookings

          Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement related to appointment scheduling within Zoho Bookings. Current Functionality: Zoho Bookings excels at streamlining individual appointment scheduling. Users can set availability

        • Zoho Bookings and Survey Integration through Flow

          I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would be

        • Service Account Admin for API Calls and System Actions

          Hello, I would like to request the addition of a Service Account Admin option in Zoho product. This feature would allow API calls and system actions to be performed on behalf of the system, rather than an active user. Current Issue: At present, API calls

        • Next Page