Tip of the Week - Conditional Formatting Chart
Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend.
Zoho Analytics allows you to format chart data points with specific color based on a condition. In this week's tip, we'll see how to apply conditional formatting over your chart.
Let's see how to format the Profit across months by the profit range.
-
Open the chart in
Edit Design
mode.
-
Add the
Profit
column in the
Color
shelf.
-
Zoho Analytics will intelligently identify the pattern in your data to categorize your data into various buckets and apply color over them. You can change this to your own specific conditions using the
Settings
page.
-
Click the
Setting
icon to open the
Settings
page and navigate to the
Legend
tab.
-
In the
Color
section, click
Custom
.
-
Specify the range to format in the
Min
and the
Max
field.
-
In the Label field, specify required name for your legends.
-
Click the
Color
tile to change color.
-
Click
Apply
. The chart will be formatted based on the conditions you have specified.
Now we have applied formatting based on a simple condition. Zoho Analytics allows you to format the chart based on advanced conditions using the
Formulas
.
Let's see how to format the same chart by the Profit Percentage based on your sales.
-
Create a formula to calculate the Profit Percentage using the following format.
sum(
"Sales"."Profit"
)/sum(
"Sales"."Sales"
)
|
-
Now categorize the profit into groups based on profit percentage. The following formula groups profit into below four groups.
-
below 50%
-
50% - 60%
-
60% - 70%
-
Above 70%
if(
"Sales"."Profit Percentage"
<
0.5,1
, if(
"Sales"."Profit Percentage"
<
0.6,2,
if(
"Sales"."Profit Percentage"
<
0.7,3,4
)))
|
-
Now add the
Profit Category
formula in the Color shelf of chart designer.
-
Open chart settings and customize the Legend.
-
Your final chart is ready.
We believe this will be useful for you. Stay tuned for more nifty tips.
Deliver unforgettable customer experiences
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
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Sticky Posts
Zoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021
[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO
Announcing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data Preparation
Zoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us
Update on the recent Apache Log4j2 vulnerabilities - Impact on Zoho Analytics On Premise Deployments
Dear Users, Three high severity vulnerabilities (CVE- 2021-44228, CVE-2021-45105 and CVE-2021-45046), impacting multiple versions of Apache Log4j utility, was disclosed publicly on December 9, 2021. We have found no evidence of any successful exploitation
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 WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.