MSIGHTS Support

In this article, you'll learn how to filter a <a href="https://s1-support.msights.com/en/articles/4062027-what-is-a-widget" rel="nofollow noopener noreferrer" target="_blank">Widget</a> to show only the top or bottom metric(s) in MSIGHTS <a href="http://s1-support.msights.com/en/articles/4124668-what-is-reporting">Reporting</a>.

This feature is effective for focusing on either top or bottom metric(s) in a table, or to reduce clutter in a chart. You may also apply this filter to both Original Source and Transformed Datasets, and to both Planned and Results Metrics. Here are the steps:

Create a <a href="http://s1-support.msights.com/en/articles/4132007-what-is-a-draft-board">Draft Board</a> if needed.

Move your mouse to the top right corner of the Widget.

When the Widget Options appear, click the gear icon to open the Widget Settings.

Move your mouse to the Metric that you want to add this filter to and click on "Advanced Options".

In the "Advanced Options" tab, go to the "Top or Bottom Results" tab. 

Select whether you want to filter for the Top or Bottom metric, and how many entries you want to include. 

Click "Apply" to save the metric filter, and click "Save" to save the new widget settings. 

Your Widget should now show only the results that match your metric filter criteria. 

1. Create a <a href="http://s1-support.msights.com/en/articles/4132007-what-is-a-draft-board">Draft Board</a> if needed.
2. Move your mouse to the top right corner of the Widget.
3. When the Widget Options appear, click the gear icon to open the Widget Settings.
4. Move your mouse to the Metric that you want to add this filter to and click on "Advanced Options".
5. In the "Advanced Options" tab, go to the "Top or Bottom Results" tab. 
6. Select whether you want to filter for the Top or Bottom metric, and how many entries you want to include. 
7. Click "Apply" to save the metric filter, and click "Save" to save the new widget settings. 
8. Your Widget should now show only the results that match your metric filter criteria. 

<b>Visual Guide (To enlarge, right-click and open in new tab)</b>

To continue learning about Reporting, please follow the link back to the Reporting Index.

Please do not hesitate to reach out to MSIGHTS Support via the messenger chat window on your bottom right-hand corner at any time or the button below for any questions, support, or feedback. We'd be happy to help!