Tip of the Week - Adding a Target Line in Your Chart
How far have you progressed? Have you reached the target or are you falling behind? Want to mark your milestones in a chart? You can do all this easily using Thresholds .
Zoho Reports allows adding up to four thresholds in a chart. With this, you can track whether your data trends between the expected ranges.
To add a threshold to your chart, click Settings at the top right and then open the Threshold tab. You can specify a static value to mark the milestone in the chart as the threshold.
You can also draw the threshold by applying functions such as Sum, Average, Minimum and Maximum over the columns in your reference axis or over a different numeric column in the database.
In the below example sales target for each region is been set in a table and this column is set as the threshold value.
Now the threshold in the chart will show the target in this column as you filter the data for each region.
Zoho Reports also allows you to set a dynamic threshold for each data point of the chart by setting the Scope as Per Cell .
In the below chart, sales target for each year has been marked as a threshold.
Zoho Reports allows you to draw more dynamic threshold using the Aggregate formula.
Here we have calculated the bugs reopened rate with the below formula and applied this as a threshold to the chart.
countif("Bugs"."Status"='Reopen',"Bugs"."Bug ID")/countif("Bugs"."Status"='Reopen' OR "Bugs"."Is Closed"=1,"Bugs"."Bug ID")*100
Few examples of charts with thresholds
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
Janani Thakshayani
desire.gasore
Sue Oh
11_Nazneen Rabia S
Joachim Zettler
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セミナー