Forsta Visualization articles are now available from a new location https://forstavisualizations.zendesk.com/hc/en-us Please be aware that we will soon remove this page.
Sort by all decimals or displayed number of decimals
You can specify, in the details project level setting, if value sorting should be based on all decimals or the displayed number of decimals.
Here we see the project level setting, the setting is applied to all StoryTeller, StoryCreator and Cross table tool reports.
Sort tied results by the internal order or alphabetically
You can specify if items with tied results should be sorted by the internal order or alphabetically.
Here we see the project level setting.
If you select to sort tied results alphabetically in a project with a Hierarchical filter you can also choose if the alphabetical order should be applied across all levels in the hierarchical structure or within each level as shown in the image below.
Here we see the setting to specify how the alphabetical order should be applied to tied H-filter nodes.
Examples: a chart shows the H-filter level 2 nodes Asia and Europe and the level 3 nodes China, Japan, Denmark, and Sweden. If, hypothetically, the result of all these nodes are tied with the same value these can be sorted in any of the following ways:
- Sort tied H-filter by internal order: Asia, China, Japan, Europe, Denmark, Sweden
- Sort tied H-filter nodes alphabetically: Asia, China, Denmark, Europe, Japan, Sweden
- Sort tied H-filter nodes alphabetically within each level, show highest level first: Asia, Europe, China, Denmark, Japan, Sweden
- Sort tied H-filter nodes alphabetically within each level, show lowest level first: China, Denmark, Japan, Sweden, Asia, Europe
You can also specify, in this project level setting, if items with low base size should be positioned at the end of their sorting group or be included in the value sorting.
Here we see an example of the new setting. In the chart to the left the normal sorting logic is applied (all the brands are sorted by value), to the right we see the new option where the brand Telecom For You is positioned in the bottom as it has a low base size.
To apply the new logic, tick the option highlighted below in the Project settings page. The setting is applied to all charts and tables in StoryTeller, StoryCreator and the Cross Table tool.
Here we see the project level setting for specifying value sorting behavior of series with low base size.
Note the following logic: The items with low base size are positioned at the end of their own sorting group and not at the bottom of the chart/table. If multiple items have a low base size these are sorted by value. Below we see an example where Other is excluded from sorting and anchored at the bottom, the rest of the items belongs to the sortable group 1. In this example two series, Telecom for You and Donut Call, have a low base size so they are positioned last in their own sorting group and sorted by value.