
01
The short answer
Start with views on: sales and gross profit by representative, progress towards target, commission calculated by gross-profit tier, conversion from pipeline stages to closed-won sales, and sales compared with the same period last year. Before sharing the dashboard, check that the data is detailed enough, the dates are comparable, and filters are not being used in place of access permissions.
Zoho Analytics lets you create reports and metrics from imported data, bring them together in a dashboard, and add filters. But the quality of the results depends on how the data is structured: reliable margin requires cost data, commission requires explicit rules, and conversion by stage requires knowing when each opportunity reached that stage.
02
Which sales metrics should you build first?
- Sales and gross profit by representative
- Show the amount sold and the margin attributed to each person. First define what “gross profit” means in your organization—for example, sales minus the direct cost of products or services. Check that cost and the responsible representative are recorded correctly in the data.
- Target attainment
- Show the amount achieved, the target for the period, and the percentage attained. The target must cover the same period and scope as the sales: a quarterly target cannot be compared directly with a year-to-date total.
- Estimated commission
- If commissions depend on gross-profit tiers, show the calculation basis, the tier applied, and the estimated amount. Have the person responsible for compensation approve the rules before treating the metric as an amount payable.
- Pipeline conversion
- Measure the proportion of opportunities that reach a given stage and eventually become closed-won. The reference period and the definition of the denominator must be visible: they change the result.
- Comparison with the previous year
- Compare equivalent periods and indicate whether the values are actual, partial, or forecast. A month-to-date (MTD) comparison should be measured against the same dates in the corresponding month of the previous year.
03
How do you calculate gross profit, targets, and commission?
Start with a sales or opportunity table that includes at least a relevant date, the representative, the amount sold, and the associated direct cost. If cost is recorded elsewhere, link the tables with a stable key, such as the sales line ID. Otherwise, an imprecise join can count sales twice or assign margin to the wrong person. In Zoho Analytics, column formulas calculate values for each row; aggregate formulas can then summarize the results in a report.
- 1Calculate gross profit for each record according to the company’s rule, such as net amount minus direct cost. Handle returns, discounts, and missing costs separately rather than automatically treating them as zero.
- 2Group sales and gross profit by representative and period. Add a consistent date filter, then check a few rows against billing or CRM data.
- 3Add a targets table with representative, period, target, and currency. Make sure the periods and representative IDs match the sales data.
- 4Calculate attainment as actual results divided by target; define what to display when the target is zero or missing.
- 5Apply commission tiers in an explicit order. For example, if the rate changes at gross-profit thresholds, determine whether the rate applies to all profit or only the portion within each tier.
- 6Validate estimated amounts using examples approved by the finance team before publishing them.
For commissions described as “real time,” be specific about data refresh. A figure cannot be more up to date than its source and the sync that supplies it. If an opportunity is changed in the CRM, check how long it takes for the change to appear in Zoho Analytics; do not promise an instant refresh without confirming it in your configuration.
04
How do you measure conversion from a stage to closed-won?
A pipeline view that counts opportunities currently in each stage does not necessarily measure conversion. To answer “what percentage of opportunities that reach this stage become closed-won?”, you need to track stage changes over time or have a reliable history. If your data only preserves the current stage, it may not show that an opportunity passed through an earlier stage.
- 1Choose the stage to study and a defined period. Specify whether the period is based on the date an opportunity entered the stage or its close date.
- 2Define the starting group: opportunities that reached the stage during this window. Keep a unique ID so you do not count the same opportunity more than once.
- 3Count how many in that group subsequently became closed-won. Conversion is that number divided by the starting group, with opportunities still open identified separately.
- 4Check opportunities that entered the stage recently. They have had less time to close; mixing them with older opportunities can make their conversion appear artificially low.
- 5Present the number of opportunities, the number won, the rate, and the last update date, rather than showing a percentage alone.
For better stage analysis, keep dated events or snapshots of pipeline history, including the stage and opportunity ID. Use a consistent rule for reopened opportunities, those transferred between representatives, or those created before the start of the period. These rules make comparisons easier to interpret and prevent a simple snapshot of the pipeline from being presented as a historical conversion rate.
05
How do you compare sales with last year without distorting the result?
The most useful comparisons match equivalent durations and dates: day against a comparable day, week-to-date against an equivalent period, MTD against the same days of the month a year earlier, quarter-to-date against the corresponding period, and year-to-date against the previous year. Specify the start of the week, time zone, currency, and fiscal calendar. If your organization does not follow the calendar year, do not assume quarters start in January, April, July, and October.
- Separate the values
- Show current actuals, the reference value, the difference in amount, and the percentage difference. A percentage without a baseline is difficult to interpret.
- Align the days
- For an MTD or YTD total, compare through the same date or the same number of business days in the previous year. Decide how to handle weekends and holidays.
- Protect the comparison report
- A date filter applied to the entire dashboard can remove the previous year’s data. In Zoho Analytics, you can exclude a specific report from dashboard filters when needed.
- Distinguish forecasts from actuals
- A forecast is an estimate based on the selected data and model, not a completed sale. Use a separate legend and presentation so forecasts are not added to actual results.
Zoho Analytics documents KPI widgets, formulas, period filters, and time-series forecasting. However, do not assume that a date filter or standard widget automatically creates every custom day-to-date, week-to-date, month-to-date, quarter-to-date, and year-to-date comparison. Define and test the comparison rule for each period, especially for equivalent days and your fiscal calendar. The forecasting feature requires a time series with a date dimension and a measure; present its result as a forecast.
06
How do you give representatives and managers the right access?
An interactive filter is a convenience, not a security barrier. If you share a dashboard with the whole team and include a “representative” filter, a user may be able to select someone else. To ensure each salesperson sees only their own results, configure permissions and row-level security criteria when sharing. Zoho Analytics supports filtering criteria and system variables linked to a user’s profile, such as their login email address.
- 1Create a reliable match between the logged-in user and the representative in the data. A normalized email address or stable ID is generally more reliable than a display name.
- 2Configure a user-level access rule and test it with a representative account. Check not only charts but also details, related reports, and permitted export options.
- 3Share a view with managers that includes their team’s data or all representatives, depending on their role. Do not grant broader access simply because a representative filter is available.
- 4Limit editing and export permissions as needed. Zoho Analytics lets you set separate permissions when sharing views.
- 5Then add convenient filters: period, team, or representative for managers. Test what happens if someone changes these filters and confirm that access rules still apply.
For the same page shared with salespeople, a dynamic filter can suit managers who want to switch between representatives, while user-level security limits what each person can actually view. These two needs cannot necessarily be handled with a single sharing configuration. Test salesperson and manager roles separately, including links to embedded reports, before deploying the dashboard.
07
In what order should you deploy the dashboards?
Avoid building every view at once. A first dashboard can bring together results by representative, targets, and trends over time. Pipeline conversion and commissions often require historical data or additional business rules; build them after validating the definitions and source data quality.
- 1Write a short metrics dictionary: formula, period, data owner, exclusions, and intended interpretation.
- 2Inventory the CRM, billing, and cost tables. Identify empty fields, duplicates, and IDs that do not match.
- 3First build sales and gross-profit reports by representative, then compare them with a verifiable sample.
- 4Add targets and commissions after validating their rules and applicable periods.
- 5Add year-over-year comparisons, then historical pipeline analysis if stage events are available.
- 6Configure filters and permissions, then test each role and each case where a filter changes.
- 7Collect specific questions from representatives and remove metrics that do not help them decide or act.
In many organizations, two paths are possible: keep Zoho Analytics and structure the missing data or calculations, or consider a custom application if the rules and access requirements go beyond what a dashboard should reasonably handle. The choice depends on the data sources, compensation rules, integrations, and maintenance required. TECHMA can help you scope the need: CRM or application, with AI where it provides practical help.
Sources
The pages the facts in this guide come from. Each link was checked when the guide was written.
- Zoho AnalyticsFormules et calculs
- Zoho AnalyticsFormules agrégées
- Zoho AnalyticsWidgets KPI
- Zoho AnalyticsFiltres dans les tableaux de bord
- Zoho AnalyticsPartage à un utilisateur et sécurité au niveau des lignes
- Zoho AnalyticsPersonnalisation d’un tableau de bord et filtres des rapports
- Zoho AnalyticsPrévision
- Zoho AnalyticsSolutions d’analyse avancée pour Zoho CRM
