Adding a threshold to a line chart based on date range

Adding a threshold to a line chart based on date range

I have a line chart that is tracking a percentage over time. It also has a filter for 50 different clients. I would like to create a threshold that is based on a portion of the date range. As I understand it, this would be done by adding a column to the data that populates with an if statement on the date. The issue is that the date range in use would be different for each client.

Is there any methodology to get this working short of individual reports for each client?


    • Sticky Posts

    • Meet the new Zoho Analytics: The Agentic Analytics platform

      Every major release of Zoho Analytics has changed what you can do with data. This one changes who does the work. For years, analytics meant a chain of hands. The engineer shaped the data, the analyst wrote the query, the designer built the dashboard,
    • [Virtual launch event] Experience the agentic analytics platform | A sneak peek into Zoho Analytics 7.0

      AI and agents are reshaping how businesses operate, and teams that can act on contextual, real-time intelligence are the ones best placed to adapt. Analytics platforms are evolving fast to meet that need. Join us for a live walkthrough of Zoho Analytics
    • What's New in Zoho Analytics - August 2026

      Hello Users! This month puts you in control of how your analytics moves: promote content safely between workspaces with Deployment Management, govern data access and sign-in more precisely, and make your forecasts smarter with external drivers. There's
    • What's New in Zoho Analytics - June 2026

      Hello Users! This month is about meeting your data wherever it lives: reaching it from AI assistants, bringing it in from more sources, and keeping it flowing with less manual effort. Here's what's new across Ask Zia and AI, data import, integrations,
    • What's New in Zoho Analytics - February 2026

      Hello Users! We're back with another round of updates for Zoho Analytics. This month's release focuses on giving you greater flexibility in how you visualize, manage, and act on your data - with new features like custom visualizations, remote MCP server,
    • Recent Topics

    • Erase function in Zoho PDF editor does not truly redact

      Using the "erase" function in the Zoho PDF editor online does not redact the text underneath when opening the file in Adobe. When I used the erase function to whiteout the areas I didn't want to be seen, I opened the supposed redacted files in Adobe.
    • Error creating an XML file

      I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} How
    • Thunderbird cannot authenticate Zoho on android

      I keep getting a message from Thunderbird on Android that it could not authenticate for my account, dadashton@zoho.com., and to update my server settings. Now the settings are exactly the same for my other devices (1 Windows, 1 Mac and 2 Linux) Can anybody
    • Mailchimp Integration

      Hello, I am needing some help. Does anybody have a recommended source for information on the Zoho-Mailchimp integration. We are working on a system to import large amounts of records into Zoho that will sync into Mailchimp for us to run a mail campaign out of. Let me explain what the process we are trying to implement - any information or advice is appreciated. Import record data base into Zoho Leads module --> use Lead source to ID records that are part of this mail campaign Zoho Leads (specific
    • [Free webinar] Zoho Creator meets AI with MCP | Creator Tech Connect (November 2026)

      Hello everyone, We are excited to invite you to another edition of the Creator Tech Connect webinar. About Creator Tech Connect The Creator Tech Connect series is a free monthly webinar consisting of purely technical sessions, where we dive deep into
    • Invalid Client - Client ID passed does not exist

      I tried connecting the Zoho campaign with the "Uncanny Automator". It shows an error " Invalid Client - Client ID passed does not exist". There is no option to add manual API. URL: https://accounts.zoho.eu/oauth/v2/auth?response_type=code&client_id=1000.MSFIUOA1G8YBK7IFRL9Z0NINM6DW9C&scope=ZohoCampaigns.contact.ALL&redirect_uri=https%3A%2F%2Fapi.automatorplugin.com%2Fv2%2Fzoho-campaigns&prompt=consent&access_type=offline
    • Field of Lookup - 5 Field Association Limit.

      This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
    • Task status - completed - other options

      I have a dumb question I know i can make custom statuses for the tasks - but is there anyway to make additional "completed" statuses like for instance if i have a task "call back customer" and i leave a vm for them to call back marking it "completed -
    • #20 I've Sent It and It's Wrong

      Meera spots a mistake in an invoice just four minutes after sending it. She has billed a photoshoot at the half-day rate instead of the full-day rate. Her first thought is to delete the invoice and start again. But is deleting the right thing to do? It
    • Zoho Forms API

      Is there any way to get all form entry list using API? Looking forward to hear from you
    • BNZ Bank Feeds No Longer Available

      The BNZ (New Zealand) bank feeds are still failing and it's been months since they last worked! Uploading bank statements (CSV's) mean waiting to the end of the month when they become available. It is unacceptable to keep my clients waiting for payment
    • MCP is now easier to access and configure in Bigin

      Greetings! We hope you're all doing well. We've previously introduced Zoho MCP for Bigin, which lets you connect Bigin with AI tools and interact with your Bigin data using natural language. Now we're making MCP easier to access and configure directly
    • Launch agents from more custom button locations and attach files in Ask Zia

      Hello all, Your agents now meet your team where the work happens. You can add agents to custom buttons in list views, create and edit pages, and related lists, so users launch them without leaving the page they’re on. What’s new Agents in more custom
    • Phone system to integrate with Zoho CRM

      I am looking for phone software that would allow my agency to do the following within Zoho CRM: Make calls from zoho Track calls and notes Leave pre-recorded messages after reaching voicemail of lead Only 2 members, so need company who will allow just
    • Introducing PRM: Build, manage, and scale your partner ecosystem

      Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
    • Zoho Projects connector with Zoho CRM (Related List module) features

      Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
    • Feature Request: Render Markdown (.md) files in Zoho Cliq

      Hi, We regularly share Markdown (.md) files in Zoho Cliq. However, when we open these files in Cliq, the content does not render as Markdown—it displays as plain text. This forces us to copy/paste the content into an external Markdown viewer to read it
    • Free webinar: Zoho Sign for Microsoft apps

      Hello, Did you know Zoho Sign works right inside the Microsoft apps you already use? A signature request shouldn't mean leaving Teams for another tab, or downloading an Outlook attachment just to sign it. Zoho Sign integrates with Microsoft 365, Teams,
    • Users can now notify the contact while adding a 'Resolution' to the ticket.

      Hello, In the latest version of the Desk iOS mobile app (v2.6.4), users can now notify the contact while adding a 'Resolution' to the ticket. Also, the 'Resolution' UI has been tweaked to support edit and delete option.   Please update the app either
    • Better Time Tracking

      We need better time tracking customization for IT MSPs. We also need reporting that is built in, rather than having to try and fumble with creating custom reports. We also need to be able to mark whether a ticket has been billed or not, I don't think
    • Introducing Custom Fonts for Career Sites

      Your Careers page is often the first place candidates interact with your organization. From exploring job opportunities to submitting applications, a consistent visual experience helps candidates recognize and connect with your brand. To give you more
    • Need help with importing expenses

      I'm using the template downloaded from the application. When I try to import my expenses, I get the message: Duplicate entry in the Expense Date column. Ensure it contains unique values. None of the rows will import. There are duplicate dates, but they
    • time tracking on zoho crm cases

      Is there a time tracking feature in zoho crm cases? I need calculate time spent in calls, tasks and events Thanks in Advance  
    • Integrate with Power BI

      Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
    • Unbundle feature for composite items

      We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form
    • Zoho Recruit: Time to Step Up Your AI Game!

      I've been using Zoho Recruit for many years and I love it. But let's be honest, it's starting to feel a bit like a relic from the pre-ai era. I recently tried out new systems that have ai resume screening and ai interviewing capabilities, these systems
    • Zoho mail app throwing network error

      Zoho mail app is throwing network error and I do not know how to fix the issue.
    • Cannot unblock account

      Hi, I have recently been travelling for work and now my mail account has been locked due to suspicious activity (I guess login attempts from different countries) however when I go into my admin panel it won’t let me unblock and asks me to contact support.
    • Time logging issues

      I am losing times tracked on tasks. The problem is that it is not clear when the time is logged, when the timer is stopped or when the task is closed? I've done both and neither works. Whats more when the task is closed, the tracked time disapperas (i guess bc it shouldve been logged) but when it's not logged you've just lost your tracked time.  The bigger problem is the UN-NATURAL way this time logging is set up. On every other plat form that tracks time, it is made clear to save timer or log when
    • Start/Stop Timmer in Chrome Extension

      The chrome extension is great and allows you to do allot however one of the most common things employees working on projects need to do is track their time. Having an easy start/stop timer to track time would be great.
    • Employee Logged Hours Report

      Hi Team, We are looking at having all Employees logged hours report, but different staff uses diferent modules to log their time. Is there anywhere that we can get a report that captures every time entered through all Zoho modules? Thank you.
    • Time Log Report Across Zoho Apps?

      Currently there are at least 4 different apps in Zoho where users can book time. Projects Desk Books People In our case for instance, the same user may book time against both Projects and Desk Tickets. So we have no way to see a simple timesheet for a
    • Zoho Time tracking option with automated screen shots.

      Time tracking option with automated screen shots would be an exceptionally good feature, any plans to develop something like that? Please do the needful. Thank you, Raj Rajinc
    • Detailed time tracking (for productivity/accountability). How to?

      Hello everyone! I read an interesting article about accurately tracking your time in 15 mins intervals and after some time analyzing it in order to improve your productivity. I'd like to give this a try myself. I would like to use Zoho apps. (How) could I do this? Thanks for the tips!
    • Time Tracking Needed in Zoho

      It seems lots of people request a Time Tracking Zoho Desktop App, that is only problem I have with working with Zoho. People need to know how much time they spend on specific tasks. Is Zoho planning to do this sometime in the future?
    • emails?

      Why can't I send emails from my account anymore
    • Backorder For Composite Items

      Hello If i released SO for composite item and use backorder feature of zoho inventory then it should backorder child item items of composite and not composite item.This is basic of backordering.I conveyed this to zoho call center but no solution yet.
    • Global Constants / Variables

      It would be great if there were a Global Constant feature. The idea here is for managing constants that are used in multiple Flows and Subflows, but might change over time. The idea is that the change could be made in one place and cascade to all future
    • Deal Activity Tracking - By Time

      Hello, I am trying to figure out a way to implement a time tracking ability within the CRP that will provide a line item on the final invoice in books. Would the Cases module be of good to use in this scenario? Want to integrate into Books as well. I
    • Time Card Tracking For Employees

      Does ZOHO have an add-on or app that my employees can use to clock in & out on a daily basis. In the past we had used a third party solution, but it was hard to use and pricey. We would really like to use your time tracking feature if you have one......if
    • Next Page