You can turn a Table widget on your Rubii dashboard into a comparison table, which shows each row's performance for the current period next to a comparison period, with the percentage change. You set this up while editing a dashboard, in the Table widget's settings.
Turn on comparison
- Click your Table widget to open its settings.
- Select the Add Comparison to Table checkbox.
The table switches to comparison view, and the comparison date controls appear.
Choose the comparison dates
- In the comparison date controls, open the dropdown.
- Select one of these options:
- Previous Period
- Previous Month
- Previous Week (Mon-Sun)
- Previous Week (Sun-Sat)
- Custom
- If you selected Custom, set your own comparison period in Choose Date Range by picking a Start Date and an End Date.
The comparison dates you choose appear in the table header.
Note: The widget's filters (for example, the campaigns it's limited to) apply to both the current period and the comparison period. There's no separate filter for the comparison period. If a different campaign or insertion order ran during the comparison period, its data isn't included unless you add it to the filter too.
Read the comparison view
In comparison view, each row in the table becomes a group of three rows:
- Current period: your data for the dashboard's reporting period.
- Comparison period: your data for the comparison dates you chose.
- Percentage change: the percentage difference between the two periods.
By default, a positive percentage change shows in green and a negative change in red. You can change both colours in the table's style settings.
The table header shows your metrics (for example, Impressions, Clicks and Conversions) and the dates of both the reporting period and the comparison period.
Edit a cell value
- Double-click the cell. The Data tab opens with the Edit Table panel.
- Enter the new values in Current value and Comparison value.
- Click Update to save the change, or Cancel to discard it.
When you double-click a cell, the Edit Table panel in the Data tab shows the Current value, the Comparison value and the Percentage change calculated from them. You can also click the percentage to change its colour.
Add and delete rows
Rows are added and deleted as a group of three (current period, comparison period and percentage change).
To add a row, use the Add Row option. Rubii adds three linked rows.
To delete a row group:
- Select any row in the group. All three rows in the group are highlighted.
- Right-click the highlighted rows.
- Select Delete.
Manage the comparison table
- Sort columns: You can sort the table by any column. Sorting is based on the current-period rows.
- Refresh, clone or delete: Click the small arrow at the widget's top right, then choose Refresh to reload the data, Clone to make a copy of the table, or Delete to remove the widget.
Note: You can't upload a CSV file to a table while comparison is on, and the upload option doesn't appear in the widget's menu. To upload, turn comparison off. You can still enter values manually while comparison is on. Download isn't available for comparison tables either.
Comparison on shared dashboards
When someone opens a shared or preview link to your dashboard, the Compare to field shows the comparison dates set on that tab's Table and Single Metric widgets:
- If the widgets with comparison turned on all use the same comparison dates, Compare to shows those dates.
- If they use different comparison dates, Compare to is left blank.
- If no widget on the tab has comparison turned on, Compare to is unavailable.
Viewers can't set their own comparison dates. To show a date in Compare to, set the same comparison dates on every comparison widget on the tab.