Learn how to create side-by-side comparison tables in seconds. At the same time, chart the differences of the columns that are most important.
Navigate to the "+ Add" tab and select "Add a comparison table".
You will then be prompted to choose the tabs you wish to compare. You can compare the original or "Analyzed Data" to any prediction. Or, if you prefer, choose any two predictions. You can even import an external ledger and use that in your comparison.
If you compare to an external ledger, there must be the same number of columns as the prediction you are comparing to, and the columns must be arranged in the same order so the column headings match.
After you choose the ledgers to be compared, choose the columns you wish to feature. These will be used to show the value differences in each row. The same data will also be used to generate graphs without any additional input.
Finally, select other columns you would like the comparison table to reference, such as year, age and premium. Then select the Compare button. The table will be automatically generated in its own tab.
Right click on any tab to assign a more descriptive name. Default names are used automatically, but descriptive tabs can save time if you have many.
To hide the sidebar and reclaim some screen space, click the toggle button that has three horizontal lines and is located in the top left of your screen.
You should not be able to see the entire table.
Scroll down to view all the rows. If you continue to scroll down beyond the table, you'll notice that the featured columns were also graphed. If you hover your mouse over the graph, you will be shown the comparison data for that year.
You can zoom in on the graph by grabbing either end of the blue line under the graph, and dragging it toward the center. This restricts the data set to the remaining years.