Sections in this category

Sorting & Filtering the Fact Table

  • Updated

Sisu allows you to sort and filter the Fact Table on any Analysis to explore the facts data any way you want.



Related Articles:



Overview of Sorting and Filtering

When viewing the Top Drivers of an Analysis, there are many ways to sort and filter the information presented to help understand its insights and implications.

  • To sort a column, click on the column name.
  • To filter a column, click on its filter icon:

By sorting and filtering the columns in any combination, you can manipulate the Top Drivers list to your specific needs.

Sorting___Filtering_-_general.png

 

Sorting & Filtering the Subgroup List

By default, Sisu sorts the Subgroups by the magnitude or absolute value of impact.

info_icon.png

For General Performance Analyses, the impact is on the metric’s performance.

For Time and Group Comparison Analyses, the impact is on the change in the metric’s performance.

For more information on impact, refer to Understanding Impact.

 

To change how the Subgroups are sorted:

Click on the Subgroup column heading to sort the Top Drivers alphabetically by name instead. (Note that this action is a toggle:  A to Z and Z to A.)

 

To add a filter to the Subgroup list:

Click the filter icon.

Filter_Subgroup_Column.png

The Number of factors section at the top refers to the number of column-value pairs included in each subgroup. Subgroups with multiple overlapping factors are referred to as “2nd order facts”, “3rd order facts”, etc., and are displayed in the list as a group, like this: A Fact or a Subgroup can be described by a set of factors. When a Fact contains one factor, it’s referred to as a 1st order fact; if it contains two factors, it's 2nd order fact, and so on. Some facts have overlapping factors, in which case Sisu displays them in a group so it's easier to look through, like this:

groups.png

In this example, the expanded subgroup displays three “orders”. Note that each order can contain multiple factors which when grouped together impact the metric’s performance.

info_icon.png Refer to Exploring Grouped Facts for more details.

 

You can filter the Subgroups in the Data Table to show only 1st order facts, for example:

 

number_of_factors.png

 

Additional actions you can perform in this filter modal:

  • Check and uncheck subgroups to include/exclude them from the Fact Table.
  • Use the Search field to quickly find a particular subgroup.
  • Click the arrow to the right of any subgroup to view all values contained in the subgroup.

Filter_Subgroup_Column_-_view_subgroup.png

Click Save to apply your filter to the Fact Table.



Sorting & Filtering by Subgroup Size

By default, Sisu lists the Subgroups by the magnitude or absolute value of impact.

info_icon.png

For General Performance Analyses, the impact is on the metric’s performance.

For Time and Group Comparison Analyses, the impact is on the change in the metric’s performance.

For more information on impact, refer to Understanding Impact.

 

 

To sort the Subgroups by Size:

Click on the Subgroup Size column heading to sort the Top Drivers by subgroup size instead. (Note that this action is a toggle: lowest to highest and highest to lowest.)

info_icon.png Subgroup size refers to the percentage each subgroup represents in the total data.

 

 

To apply a filter to this column:

Click the filter icon in the Subgroup Size column.

Filter_Subgroup_Column.png

Actions you can perform in this filter modal:

  • Check and uncheck size values to include/exclude them from the Fact Table.
  • Use the Search field to quickly find a particular subgroup size.

Click Save to apply your filter to the Fact Table.

 

 

Sorting & Filtering by Subgroup Metric Value

By default, Sisu sorts the Subgroups by the magnitude or absolute value of impact.

info_icon.png

For General Performance Analyses, the impact is on the metric’s performance.

For Time and Group Comparison Analyses, the impact is on the change in the metric’s performance.

For more information on impact, refer to Understanding Impact.

 

 

To sort the Subgroups by Metric Value:

Click on the Subgroup Metric column heading to sort the Top Drivers by subgroup average value instead. This column will be labeled with the calculation type that was used in the Analysis (i.e., Average, Sum, Count, Rate, or Row Count).

Note that this action is a toggle:  lowest to highest and highest to lowest.

 

info_icon.png

Refer to Understanding Sisu's Analysis Types for more information.

 

 

To apply a filter to Subgroups by Metric Value:

Click the filter icon in the Subgroup <Aggregation Method> column (i.e. “Subgroup Average”, etc.).

Filter_Subgroup_Calculation_Type_Column.png

Sisu allows you to filter one of two ways:  by change in value or by absolute value.

To filter by change in value:  Select a condition to filter by, then type a value in the second field (e.g., greater than 50%), and click Save.

To filter by absolute value:  Select a condition to filter by, then type a value in the second field (e.g., greater than 20), and click Save.

 

 

Sorting & Filtering by Impact

By default, Sisu sorts the Subgroups by the magnitude or absolute value of impact

info_icon.png

For General Performance Analyses, the impact is on the metric’s performance.

For Time and Group Comparison Analyses, the impact is on the change in the metric’s performance.

For more information on impact, refer to Understanding Impact.

 

 

To sort the Subgroups by Impact:

Click on the Impact column heading to sort the Top Drivers by impact on performance. (Note that this action is a toggle:  lowest to highest and highest to lowest.)

 

To filter Subgroups by Impact:

Click the filter icon in the Impact column.

Filter_Impact_Column.png

 

By default, Sisu displays both positive and negative drivers, but you can choose to display only positive or only negative drivers. 

You can also select a condition to filter by, then type a value in the second field (e.g., greater than 50%), and click Save.

Click Save to apply your filter to the Fact Table.