How to create month-on-month target vs achievement report
Hello,
We would like to set monthly target project completion % for our project locations, and allow location managers to submit actual % completion achievement on the last date of each month.
Eg. we would set April target as 5% completion, May target as 10% completion and so on for the whole year. Location managers would send in actual completion % as say 4% at the end of April, 8% at the end of May, etc.
The report would show the month-by-month target vs achievement numbers.
Is the above possible in Zoho creator report? How should I go about creating this kind of report?
Thank you in advance.
Access your files securely from anywhere
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
ruchi
Manikandan
Vinnie B - bcCloudTech
Sticky Posts
Zoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continueZoho Creator User Group meetups in a city near you! - Oct - Nov, 2023
Greetings from the Zoho Creator team! We're hosting a series of Zoho Creator meetups in various cities across the globe, and we'd love to meet you there! Our meetups are a great opportunity to network with industry peers, exchange ideas and best practices,Zoho Creator - 2023 Release Projection 2
Hello everyone! Time truly flies when you're having an incredible journey, and today we mark the completion of an eventful and action-packed six months. It feels like just yesterday when we embarked on this adventure together with the launch of our newUpcoming Updates - August 2022
Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. AIntroducing Zoho Creator's v2 APIs
Hello App Creators, Welcome to Zoho Creator's v2 APIs! This post will serve as the central point for migrating implementations of Creator's current APIs (v1) to v2. Improvements that v2 brings OAuth-based authentication, which is more secure than the
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns 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
Scheduling Actions by Date and Reusing Webhooks in Journey Builder
Hello, I’m trying to use the Journey Builder feature, but I noticed that it only allows scheduling actions forward in time, not based on a specific date. It would be very helpful if we could schedule actions ahead of time based on predefined date fields.New Customization options in the module builder: Quick Create and Detail view
Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the numberProject Change Orders and Additions
We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure outCreate Invoice With More Than One Item/Product
I was trying to use Zoho Flow to automatically create an invoice when an opportunity is marked won in Zoho CRM. However, you can only add one item/product using the Create invoice module. Is it possible to add more than one item/product to the same invoice?Formulae field(Sum) not updating when a sub form entry is deleted
Hi there, I was facing this issue wherein I have a main form called 'Work_order_Form' and in that main form I have a sub form called 'Items' and in that items I have a field called 'Print_Charges'. So in my main form I have a formulae field which calculatesRegarding the integration of Apollo.io with Zoho crm.
I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on GoogleCount of Distinct IDs when they appear multiple times within a selected time period
I have a transactions table which includes the columns: date, customer_id and order_id. I want to be able to count the distinct customer_ids within a date range when those customer_ids appear across multiple rows (because they have multiple orders withinHow do I append customer number to invoice number?
New Zoho Books customer using the free trial and trying to figure out how to append the customer number to the invoice number. For example, my customer number is: ACME My current invoice number is: 24-XXX I would like my invoice number to be: ACME-24-XXXXDouble spacing issues in Zoho Mail
Some of my emails are double spacing and others our single space very anoying, wanted to know how to fix the problem. Also, can't get my signiyure on my emails to be singled space someone please help!!!!!Have an input card for zobot that could collect Name, Email, and Phone or a message all at once
It would be great to have an input card for the codeless bot in a form style that allows it to ask all relevant questions at once. at any point in the chat flow or conversation, This approach would simplify the interaction, making it easier and more straightforwardWebhook Failure Alerts and Retry Mechanism
Dear Zoho Team, I have a workflow in Zoho CRM that sends a webhook whenever a specific field is updated. Occasionally, the workflow fails, and I can manually check the errors under Settings > Automation > Actions > Webhook > Failures. However, these failuresZoho CRM not saving edited quotes
When I am editing existing quotes, zoho CRM often gets stuck and I see only the red circle with line through it when I try to save my edits for that quote. This is destroying my workday. Help please!Introducing the Zoho Sign and Bigin integration
Greetings, We're thrilled to announce that Zoho Sign has integrated with Bigin by Zoho CRM, bringing a seamless signing experience directly into your small business CRM. You can now sign, send, and manage your contracts and agreements directly from yourZoho Survey Partially Completed Send Reminder to Complete the Survey
I have couple of survey's set up through a link webform. These survey's are not being distributed through email, only a website link. We get more than 50% partially completing the survey. Is there a way to send an email to these people? I looked underDynamic Variables for Organization Names in Forms and Emails
I’m currently using your platform to distribute a standardized questionnaire to various organizations, and I would like to make the experience feel more tailored to each recipient. Specifically, I’m wondering if it is possible to use a dynamic variableMigrate from crm plus a zoho
Hello, it turns out that I migrated my account from CRM Plus to Zoho One on the same administrative license, and when I reviewed what CRM, Desk and Sales are, IQ they are with another organization, I do not migrate, for example I enter CRM and I can seeCustom Modules - Zoho Desk - iOS
Hello, everyone! In the iOS version(v2.8.9) of the Zoho Desk mobile app, we have introduced support for custom modules as a related item to the standard modules like Tickets, Contacts, and Accounts. This new feature allows you to capture unique informationUpdate Candidate Status Through Workflow in Blueprint
Hi Team, We have a blueprint built out with custom functions that update particular fields based on candidate actions. When particular fields are updated we need to move the candidate forward in the blueprint. We tried to do this through a workflow,QR Code generation - native
All, FYI Google have recently depreciated their QR Code API refer: https://stackoverflow.com/questions/55021765/deprecation-of-google-infographics-qr-codes Annoyingly, this has meant we needed to change our links over to another provider. Creator team:Double Value in KPI - Zoho Analytics
Hi Team, I tried to implement this in Zoho Analytics but couldn't figure it out. Here's the scenario: I want to display the total number of tickets created, along with the count of closed and in-progress tickets, all in a single KPI. How can I achieveRich-text fields in Zoho CRM
Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatileArchiving Contacts
How do I archive a list of contacts, or individual contacts?Change default identifier field in custom module
Hi, i have searched through several community posts and helpdesk articles but i have not been able to find a proper solution for our problem yet. We have created a new module which aims to provide similar functionality as the default "accounts" module.Unveiling Cadences: Redefining CRM interactions with automated sequential follow-ups
Last modified on 01/04/2024: Cadences is now available for all Zoho CRM users in all data centres (DCs). Note that it was previously an early access feature, available only upon request, and was also known as Cadences Studio. As of April 1, 2024, it'sZoho Books - Branches - Can I cross-charge between branches?
Hi, We have two parts of our company, manufacturing and sales. The manufacturing side will invoice/bill the sales side for the materials and labour on each order. I have recently discovered the Branches feature in Books and it fits well with our setBooks Custom function - Not executing..
Use case : Module involved = Invoice When an Invoice is "Approved", the "current date" is more than "n" days and the "Amount" to be received is more than 0 I want a cliq message to be triggered in a channel and to be executed Daily(Scheduled) at 10:30Delete Transactions in Zoho books
Hi, Zoho books have been migrated from 01.04.2023. However, there are few transactions passed for the period 01.04.2022 to 31.03.2023. I would like to delete all the entries passed during that period. Can you please help in deleting the same.Generate access token(Google OAuth 2.0) dynamically using deluge
How to generate Google OAuth 2.0 access token dynamically using deluge to Add the zoho books invoice data in google spread sheet.Placeholders for Multi-Level Discount
I am using custom templates for Invoices and all other modules. Since i have activated multi-level discount (an early-access feature from zoho) "discount at line-item and transaction level", I need placeholders for using them in my custom templates. WithPower of Automation: Streamline status update for linked issues.
Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. We haveHow to have two separate views for different countries
Hi there, currently i have two offices i want to add to zoho crm, one office is in singapore which i have already implemented fully. The other office being malaysia which i want to implement. One issue with this is we want the malaysia office users toTicket View Across Departments
I setup departments for the main clients I service, tickets inbound from specific emails go right to the departments. This helps with reporting for me. I would like a view of tickets assigned to agent, or unassigned, across ALL departments. Basically I am handling tickets across 3 departments, but I have to keep switching to see what tickets i have. I would like a view where I look and see ALL tickets across ALL departments.Merging 2 tickets
Hi I understand how to merge 2 tickets already but find the process quite cumbersome. It is not always simple to perform a search that causes the 2 tickets in question to show up on the Ticket Screen, and this is the only place a merge can be performed. Doing a search for the customer or contact linked to the ticket displays all of their tickets which could be hundreds to sort through, you could do a custom search that only shows open tickets but doing that every time is also time consuming. NotEmailing a document to WorkDrive
Does WorkDrive include the ability to upload a document by sending an attachment to an email address? (Books and Expenses include this functionality) If it doesn't is it under consideration? on the Road Map?【開催報告】 東京 ユーザー交流会 2024/11/29(金) Zoho Oneを活用した社内DX推進事例の共有
皆さま、こんにちは。コミュニティチームの藤澤です。 11/29(金)に東京ユーザー交流会を開催しました。10月の開催回に引き続き、多くのユーザーさんに参加いただきました！以下に各セッションの概要と登壇資料も掲載しています。ぜひご参照ください。 Zoho活用事例セッション：Zoho Oneで決め打ちDX~導入過程からコスパ・タイパを極めて効率化~ 今回は、株式会社T h e F l o wの若林さんに登壇いただき、Zoho One を活用した社内DX推進のことや、そもそも「DXとは何か？」というようなDXの本質に迫った内容まで多岐にお話しいただきました。以下に当日の発表内容と資料を一部抜粋して記載しています。Product Request: Send email to Secondary email
Guys, we should be able to send the campaign to the secondary email too. Is this on the plans for Zoho Campaign? It looks like I can map the secondary email from the CRM to the Campaigs, but can not send the message.Logic for sending to a non-primary email address
Hi, I have a scenario where contacts are able to sign up for emails with 2 different email addresses (example: work, personal). I've mapped both to Campaigns from Zoho CRM, but when I go to target an email only the primary email addresses are pulling in. How can I update this to look at both of the email addresses - or specifically the secondary email address in Campaigns? Thanks, JennyTicket Status Colors
Can i change the colors of Ticket Status in the admin panel? Or even change the background of the entire cell of a Critical ticket? This way its easy for my agents to see a urgent ticket when it comes in. Right now everything is black text. Here RightZoho Sites and CloudFlare DNS issue over HTTPS
I have a Zoho Site with a custom domain voterprotectioncorps.org NameCheap is the registrar CloudFlare is the DNS manager, using custom Nameservers (see attached) I installed the SSL cert via Zoho Sites (the "Add SSL cert" option that installs the freeHow do I do a formula to join two fields together like first name and last name into full name?
Having issues with this in my custom module. In most CRM systems you would do: FIELD1 & " " & FIELD2 But it gives an error saying I'm not supposed to use double quotations so not sure what that means. I've tried to read the formula help guide but it'sNext Page