Understanding trends in your model

Discovering trends

In Runway, you can use charts to track how key metrics change over time.

For deeper insights, you can use:

Time Comparisons: Compare your driver values across different time periods, such as Month-over-Month (MoM), Quarter-over-Quarter (QoQ), or Year-over-Year (YoY).

Custom Rollups: Aggregate values over specific intervals, like quarterly or annual, to see aggregate driver values for periods like "Year-to-date."

You can combine both tools to create powerful reports and visualizations that help you spot trends and tell clear stories about your business.

Working with Time Comparisons

Follow these steps to compare driver values across time periods:

Go to any model under the ‘Models’ section in the main nav in Runway.

Click Customize at the top right, then select Compare.

Choose the Time period you want to compare (e.g., MoM, QoQ, YoY).

Select the metrics you want to display. Each time period will show up as a separate row in the time series table.

🔎

Time Comparisons display data for the current Scenario. If you want to compare values across Scenarios or Snapshots, check out Scenario Comparison and Budget vs. Actuals.

Working with Custom Rollups

Say you want to roll data up over specific intervals to answer questions like:

"How much money have we made so far this year?"

"Did we experience seasonality during any specific quarter?"

Here’s how to do it:

Go to any model under the ‘Models’ section in the main nav in Runway.

Click Customize at the top right, then select Rollups.

Pick a rollup option from the menu. You can choose from:

Monthly, Quarterly, or Annual

Quarter to date, Half-year to date, or Year to Date (this sums up to and including the current calendar month)

Quarter to last close, Half-year to last close, or Year to last close (this sums up to and including the month marked as last close)

Trailing three, six, or 12 months (relative to current calendar month)

When selected, the rollup values will appear as separate columns in the time series.

💡

Need a custom rollup? Let us know via Slack or email us at success@runway.com.

Combining Time Comparisons and Custom Rollups

With a few clicks, you can combine both tools to create reports that highlight the growth, challenges, and opportunities of your business.

For example, you can quickly generate a quarterly report that compares this year’s performance to last year’s. Here’s how:

In the Customize menu at top right, select Compare → Time period → 12 months ago.

Next, select Rollups → Custom rollup → choose both Quarterly and Annually.

Couldn’t find what you were looking for? Try typing your query in the search bar above, or feel free to get in touch with our support team.