All Collections
Flightpath Finance
Dashboard
Comparison Table (Scenarios)
Comparison Table (Scenarios)
Baremetrics avatar
Written by Baremetrics
Updated over a week ago

After creating your first scenario, you might want to compare your Baseline forecast against it. A Comparison Table is a perfect tool for the job, as it let's you set two or more columns side by side, while pulling data from different sources.

1. Create a Table

Navigate to your dashboard to create a table. Select Add a Table at the bottom of the page.

2. Name the Table

Write down the Table Name, and select Advanced as the Table Type. Click on both Add a Row, and Add a Column buttons, and you should see something like this:

3. Create Scenario 1 Column

Edit the first column by clicking on the header of the Column 1. Use the sidebar on the right to change the column name to the name of your scenario, say, "Baseline." Don't change the snapshot but leave it as current. Finally, select the time period from the Date Range drop-down. In this example we are looking at January - April 2021.

4. Create Scenario 2 Column

Create a 2nd column by clicking on Add a Column. Change the name to the scenario name, say, "Aggressive" and change the Date Range to match the time period of the Baseline column. Leave the Snapshot setting as Current, but change the Scenario to Aggressive (or whatever you named your scenario as).

5. Add Rows to the Table

Add additional rows. There is no need to change any Column properties for any additional rows as they inherit the settings you set during the steps #3 and #4.

6. Save & Close

Select Save and Close, and your Scenario Comparison table will be visible on the dashboard. You can re-size the table and move it around the dashboard.

Did this answer your question?