Reports can now be filtered using dynamic criteria values

Reports can now be filtered using dynamic criteria values

Dear All,


We are here with a quick and a useful update to the new reports feature in Zoho CRM.

As you may know, the new reports feature lets you create different types of reports in just a few clicks. Just select the parent module, choose the child module, and determine their relationship. Additionally, using column grouping and filter criteria, you can neatly organize the datasets for a targeted analysis.

Today's announcement is about data filtering in the new reports. Let's get into the details!

Adding a filter to a report is a great way to cleanse your data. You can define one or more criteria based on the fields from the selected modules and ascribe values to tabulate the records, as desired.

For example, to conduct a campaign revenue analysis, you can use the criteria to view only those records whose actual cost have crossed the defined threshold - USD 50,000. This way, you can ensure only the qualified data are displayed.

Thus far, you were only able to add a static value to the criteria. USD 50000 is a static value, where the reports will bring in records that meets the said value.

While denoting a value to sift your report is useful, for a more granular analysis, mere static value becomes insufficient.

Imagine you want to assess your campaigns spends and you want to look at all the campaigns in your organization whose actual cost is above than the budgeted cost. Here, the budgeted cost could be higher than the static value (USD 50,000) or the actual value itself could be lower than the static value. In both cases, the resultant report will be insufficient and inaccurate.

To address this discrepancy is why we have introduced the ability to denote another field from the selected modules as criteria value.

For the same example, you can use the fields—actual cost and budgeted cost from the selected modules as filter criteria and draw a contextual and meaningful report.

Likewise, you can use CRM fields as dynamic values in criteria and derive insightful analysis on your business performance.
Here are some more examples.
  • Example 1: You can add a filter to the report to display quotes whose allowed adjustment is greater than the discount offered. You can retrieve this information and investigate the process error.

  • Example 2: By adding the following criteria, you can view all your deal closures that are neck and neck to the actual due date.

    and so on.

  • The fields used in a criteria should be of the same data type. That is, if the field type in your LHS of your criteria is a date type field, the field in the RHS should also be of the same date type field.

  • All the fields present in the selected module(s) will be displayed in the criteria.
  • For joined reports, the filter will be configured and applied for each report.

  • Currently, you can only use the following field type as criteria value:
    • Date, date and time
    • Checkbox
    • Number, decimal, percentage, and long integer
    • Currency
      If multicurrency is enabled in your organization, you can use the fields from the same module to compare and filter. If multicurrency is not enabled, fields from both the selected module and its related modules are listed. You currently cannot use other data types like picklist or look up fields to compare and qualify.
  • In the filter, you can compare fields belonging to the immediate parent modules and immediate child modules.
  • Even if you choose fields with empty values in a criteria, the report will run and tabulate results based on the criteria.
  • If one of the fields has a value and the other doesn't, then based on the selected operator, the report will or will not be displayed.
  • You can add up to four filter criteria for a report.
That's it for the update. This update is now open for all users in all DCs. Click here to access help documentation.

Thanks and have a good one!

Kind regards, 
Saranya Balasubramanian

            Zoho Marketing Automation
                      • Sticky Posts

                      • Canvas templates can now be shared with different CRM organizations

                        ----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help
                      • Gamescope is leveling upto Motivator for Zoho CRM

                        Hello,   As you are aware, we recently made Motivator for Zoho CRM available for Zoho One, CRMPlus and CRM Ultimate editions. Since Motivator has all the features of Gamescope and even more advanced gamification, we are planning to EOL Gamescope on 30th
                      • Announcement! Early 2023 Release | Zoho CRM & You–Go Further Together

                        Greetings from the Zoho CRM team! Zoho CRM is evolving at an unprecedented rate– new features and enhancements are constantly being added that elevate its capabilities and help businesses make the most of the tool as well as the information they have,
                      • Introducing a new home page view and UI enhancements for Dashboards

                        Hello everyone,  In CRM, the home pages provide a quick view of the various happenings in a business with the help of dashboards. The home pages also help to organize one's and the team's day's work. There are three views in the home tab: Classic User's
                      • Subforms can now be marked as required

                        Dear All,   Hope you are well! We are here with a heads-up about an important enhancement for Subforms. Let's go!   Including a subform to a record layout is a great way to store supplementary information about the record. Be it the list of products purchased

                      Zoho Pagesense Resources

                        Zoho SalesIQ Resources

                              Zoho TeamInbox Resources

                                Zoho DataPrep Resources

                                  Zoho CRM Plus Resources

                                    Zoho Books Resources

                                      Zoho Subscriptions Resources

                                        Zoho Desk Resources

                                          Zoho Projects Resources

                                            Zoho Sprints Resources

                                              Qntrl Resources

                                                Zoho Creator Resources

                                                  Zoho WorkDrive Resources

                                                    Zoho Campaigns Resources

                                                      Zoho CRM Resources

                                                            Design. Discuss. Deliver.

                                                            Create visually engaging stories with Zoho Show.

                                                            Get Started Now