What-If Analysis
Zoho Analytics supports What-if Analysis using Variables. What-If Analysis enables you to do powerful scenario analysis on your data. It enables you to measure the difference in outcome when one or more variables change. This helps in effective decision-making, as you can visualize the business impact that can arise from such changes ahead of time.
Setting up What-If Analysis
This section explains how to set up a What-If Analysis.
Step1:
Create a Variable to parameterize the dynamic input for What-if Analysis.
Step 2
:
Use the Variable in the Aggregate Formula to compute the metrics you want. The formula will essentially capture the impact of the variable.
Step 3:
Create a report using the Aggregate formula stated above.
Step 4:
Add the Variable in the User Filter of the report or dashboard. This User Filter will act as the dynamic input for the report or dashboard.
Creating Variables
Zoho Analytics What-if Analysis allows you to visualize the impact of one or more parameters over your metrics. To parameterize dynamic inputs for your What-if Analysis, you need to create a Variable. Create a Variable with a List or Range of values as what-if input. In the below example, we've defined a list of discount percentages as a variable.
Creating Aggregate Formulas
Construct a formula to compute your metrics. Insert the custom variables you have defined in step 1 appropriately in the formula so that you can visualize the impact as the dynamic value changes. You can insert one or more custom variables in your formula by clicking the variable in the Variables tab.
The below formula uses the variable
Discounts
to calculate the
Discounted Prices
.
sum
(
"StoreSales"."Price"
)-(
${Discount}
/
100
)*
sum(
"StoreSales"."Price"
)
Creating Report
Create a report using the Aggregate Formula in step 2. The report will show the values based on the default value defined in the Variable.
In the below report, the Discounted Prices will be calculated for 10% discount based on the default value defined in the variable.
Adding Variable as User Filter
All the Variables associated with the report will be listed in the Variables tab of the report designer. Add the Variable as a User Filter in your report. This allows you to change the formula input and thus make a dynamic calculation.
We've added the variable Discounts as a User Filter.
In the below example, as you change the discount, the Discounted Price will be calculated accordingly.
Customizing What-If variable for Shared Users
You can define different sets of values for your shared users depending on the need .
Here, we have defined different discount ranges for various user groups or user email addresses.
When the shared users access the report, the user filter will list all the variable value specified for them. they will be able to change the value to vizualize the impact of the variable.
The below presentation explains the above-stated steps in detail.
Solutions
The following are a few demonstrative sample solutions for What-If Analysis.
Solution 1: Discount over Sales
The below solution explains how to calculate the influence of Discounts over Sales.
Solution 2: Win Rate % against Won Deals
The below solution explains how to calculate the impact of Win Rate % against Won Deals.
Solution 3: Projected Sales
The below solution explains how to create a report with Projected Sales with the possibility of -50% to 50% revenue change.
Solution 4: Change Summary Function
You can also apply different calculations within a report for each variable value.
The below presentation explains how to visualize different summary functions within the same report.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
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
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Auto Analysis
Zoho Analytics provides Augmented Analytical capabilities using technologies like artificial intelligence (AI), machine learning (ML), and natural language processing (NLP) in various scenarios. One such feature is to auto-generate reports and ...Cluster Analysis
Clustering is a method used in data analysis to group similar data points together based on certain factors or similarities. Each cluster contains data points that are more similar to each other than to those in other clusters. Zoho Analytics uses ...Cluster Analysis
Clustering is a method used in data analysis to group similar data points together based on certain factors or similarities. Each cluster contains data points that are more similar to each other than to those in other clusters. Zoho Analytics uses ...Advanced Analytics for QuickBooks
Zoho Analytics Advanced Analytics for QuickBooks empowers you with financial analytical capabilities over your QuickBooks Online data. With this connector, you can create insightful reports & dashboards over your QuickBooks data for in-depth ...Introduction to Analysing Data
Zoho Analytics enables you to analyze your data with advanced analytical options. You can easily predict future values or identify the past & future trends in your data with a simple process, without worrying about the underlying complexity. You can ...
New to Zoho LandingPage?
Zoho LandingPage Resources