The new Looker dashboards provide updated reporting experiences for Payments, MRR, ARR, Customers, and Contracts.
As part of the dashboard migration, some metrics and visualizations use updated calculation methods, reporting periods, or currency conversion rules. As a result, figures displayed in the new dashboards may differ from those in the existing Ordway home dashboards.
This article explains the key differences, what to expect when reviewing dashboard metrics, and why some values may not match across charts, summary cards, and reports.
Contents
- Overview
- Why Dashboard Values May Differ
- Payments Dashboard
- MRR Dashboard
- ARR Dashboard
- Customers Dashboard
- Contracts Dashboard
- Frequently Asked Questions
Overview
The new Looker dashboards use updated reporting calculations for several metrics.
Although the dashboards display similar metric names and reporting categories, the underlying calculation methods are not always identical to those used in the existing home dashboards.
You may notice differences in:
- Summary card values and chart totals.
- Plan and Product distribution.
- Historical MRR and ARR values.
- Active Customer and Active Contract counts.
- Renewal amounts and customer rankings.
- Results for customers using multiple currencies.
These differences do not necessarily indicate missing or incorrect data. They can result from differences in how metrics are calculated, grouped, or filtered.
Why Dashboard Values May Differ
Dashboard values may differ for several reasons:
| Factor | Why values may differ |
| Calculation method | Different dashboards may use different calculation methods for similarly named metrics. |
| Reporting period | Some metrics use the selected date range, while others use month-end snapshots or fixed reporting windows. |
| Date basis | Metrics may be calculated using Payment Date, Invoice Date, Service Start Date, or Contract-related dates. |
| Currency conversion | Different dashboard metrics may use different currency conversion methods. |
| Aggregation | Some metrics count distinct Customers or Contracts, while others aggregate amounts or monthly values. |
Important: Not all dashboard tiles are designed to reconcile with one another. Review the metric definition and reporting period before comparing values.
Payments Dashboard
Distribution by Plan and Product
The Payments dashboard includes Plan and Product distribution visualizations.
These visualizations are based on invoice line values associated with qualifying payments. They do not represent a direct allocation of the actual payment amount across Plans or Products.
As a result:
- A partially paid invoice may contribute the full value of its associated invoice lines.
- Multiple qualifying payments against the same invoice may contribute the associated invoice line values more than once.
- The distribution total may not match the Total Payments summary value.
Payments and Invoices Date Differences
The Payments and Invoices distribution charts use different date criteria.
- The Payments distribution is based on Payment Date.
- The Invoices distribution is based on Invoice Date.
Because the charts use different dates and transaction associations, their totals and distributions may differ.
MRR Dashboard
Historical MRR Cards
The 30, 60, 180, and 365 Days Ago cards display MRR using a month-end snapshot for the corresponding historical reporting period.
This provides a point-in-time MRR value rather than adding together multiple monthly MRR balances.
You may therefore notice differences when comparing these cards with historical values in the existing home dashboard.
Net New MRR
Net New MRR is available in the summary and detailed table. However, it is not displayed as a separate series in the main MRR chart.
Net New MRR – Last 30, 60, 180, and 365 Days
The rolling Net New MRR cards use monthly movement data within the selected reporting window and compare it with the preceding window.
Because the calculations use monthly reporting periods, partial months and reporting-period boundaries can cause differences when compared with the existing home dashboard.
Net New MRR Percentage Change
The Looker dashboard calculates Net New MRR percentage changes using the absolute value of the previous period as the comparison baseline.
This helps maintain the correct direction of the percentage change when the previous period has a negative Net New MRR value.
Plan and Product Distribution by MRR
The Looker dashboard calculates Plan and Product distribution using the latest available month-end MRR values within the selected dashboard period.
The existing home dashboard uses a different calculation based on recurring subscription charges.
Therefore, Plan and Product distribution amounts and rankings may differ between the two dashboards.
The Looker visualization displays the top five groups and combines the remaining groups into an Others category.
Top Customers by Total MRR
Customer rankings may differ between the existing home dashboard and the Looker dashboard because the calculations use different MRR values and currency conversion methods.
For customers using multiple currencies, related MRR visualizations may also show different totals because they do not all use the same currency conversion basis.
ARR Dashboard
Total ARR and Net New ARR
The ARR summary cards display annualized values calculated from MRR multiplied by 12.
Some charts and detailed breakdown tables continue to display MRR-based values.
As a result, summary values may not directly match the amounts displayed in the charts and tables. Check the metric and unit displayed before comparing these values.
Plan and Product Distribution by ARR
The ARR Plan and Product distribution is based on MRR distribution values multiplied by 12.
The Top Customers by Total ARR visualization uses a different stored ARR value.
Therefore, Plan and Product distribution totals may not reconcile with the Top Customers by Total ARR visualization.
Customers Dashboard
Active Customers
The Looker dashboard calculates Active Customers using Customers represented by qualifying subscription-charge activity in the reporting period.
Customers who only have orders, or subscriptions without qualifying represented charges, may not be included.
The count may therefore differ from the existing home dashboard, which uses a different activity calculation.
Active Customers Summary and Monthly Chart
The Active Customers summary represents distinct Customers across the entire selected reporting period.
The monthly chart calculates the Customer count separately for each month.
Because the summary and chart use different reporting periods, the summary value may not match the last monthly chart value.
Net New Customers
The Looker dashboard calculates Net New Customers using distinct Customer counts associated with New and Churn movements.
The results may differ from the existing home dashboard, particularly for Customers with zero-MRR subscription activity.
The rolling Last 30, 60, 180, and 365 Days Net New Customers cards are not included in the current migration.
Top Customers by Lifetime
The Top Customers by Lifetime visualization uses invoice amounts and includes non-reversed invoices dated on or before the selected reporting end date.
The selected start date does not restrict the lifetime calculation.
This means the visualization represents lifetime invoice activity through the selected end date rather than activity limited to the entire selected date range.
Contracts Dashboard
Active Contracts
The Looker dashboard calculates Active Contracts using distinct Subscriptions represented by qualifying subscription-charge activity in the reporting period.
Contracts without qualifying represented charges may not be included.
Consequently, Active Contracts counts may differ from the existing home dashboard.
Active Contracts Summary and Monthly Chart
The Active Contracts summary uses the exact selected reporting-period boundaries.
The monthly chart evaluates activity over complete calendar months.
If the selected reporting period begins or ends in the middle of a month, the summary and first or last monthly chart values may differ.
Past Renewals
The Looker dashboard uses renewal data within the selected reporting period to calculate Past Renewals.
Unlike the existing home dashboard, this calculation does not include evergreen billing-schedule renewal events.
Therefore, Past Renewals totals may differ between dashboards.
Upcoming Renewals
The Upcoming Renewals visualization uses a fixed next 180 days reporting window.
It does not follow the selected dashboard date range.
The calculation also does not include evergreen billing-schedule renewal events.
Keep this behavior in mind when comparing Upcoming Renewals with other dashboard metrics.
Frequently Asked Questions
| Questions | Answers |
| Why do the new Looker dashboard values differ from the existing home dashboard? | Some metrics use updated calculation methods, date criteria, aggregation rules, or currency conversion methods. Review the metric-specific explanations in this article when comparing values. |
| Why do summary cards and charts sometimes show different values? | Summary cards and charts may use different reporting periods or calculation methods. For example, a summary may represent the entire selected period, while a chart displays individual monthly values. |
| Why do Plan and Product distribution totals not match the summary values? | Distribution charts may use different calculation bases from summary metrics. For example, the Payments distribution uses associated invoice line values rather than allocating actual payment amounts. |
| Why do MRR and ARR values differ? | MRR and ARR use different reporting units. ARR summary values are annualized by multiplying MRR by 12, while some charts and detailed tables may display MRR-based values. |
| Why do dashboard metrics show different amounts for multi-currency Customers? | Different dashboard metrics may use different currency conversion methods. This can cause related charts and summary values to differ. |
| Why is Upcoming Renewals not affected by my selected dashboard period? | Upcoming Renewals uses a fixed next 180-day reporting window rather than the selected dashboard date range. |
Comments
0 comments
Please sign in to leave a comment.