In this article, we will provide a guide on how to configure and use the comparison feature in MSIGHTS Reporting.
Adding the Comparison feature to your widget allows users to contrast current performance against historical data, unlocking deeper business insights at a glance. Follow this step-by-step guide to configure comparisons for both group and simple tables.
Step-by-Step Configuration
Prepare your workspace: Create or open a Draft Board if you haven’t already.
Add the widget: Insert either a Simple Table or a Group Table onto your dashboard.
Set the timeframe: Select your desired active Date Range.
Enable comparison: In the Widget Options panel, toggle on the Include Period Comparison option.
Select the historical period: Choose the past timeframe you wish to compare your current data against.
Save your changes: Once you are satisfied with the configuration, click Save to apply the settings.
Understanding the Comparison Data
After configuring and saving your table, the widget will display three distinct metrics within a single cell for each row:
The Variation Percentage: Highlighted in green (for positive trends/growth) or red (for negative trends/declines), indicating the percentage of change.
The Historical Value: The top number displays the data value from your chosen past period.
The Current Value: The bottom number displays the data value for the active period.
Example Context: In the screenshot above, you can see that spending has increased across all applications this year when compared to the previous period.
Please do not hesitate to reach out to MSIGHTS Support via the messenger chat window in the bottom right-hand corner at any time or the button below for any questions, support, or feedback. We'd be happy to help!