Categorical Data : How to change order of categories?
Keshif supports three modes for ordering categories.
- Dynamic Ordering
- Custom (Fixed) Ordering
- Alphabetical Ordering
Dynamic Order - Most frequent/largest category first
Keshif dynamically orders the categories to reveal the most common categories first, and updates the ordering after filtering, which changes distributions and relevant categories. Dynamic ordering is enabled by default to help you rapidly explore the most frequent in trends. You can re-enable dynamic ordering by opening the configuration, and selecting Dynamic order.
Custom Fixed Order - Using Logical / Likert Order
In some cases, you may want to define your custom category order, and keep the order fixed. This is useful if your data has logical order (such as "small", "medium", "large", "huge", and likert-scale survey responses). Fixed ordering can sharpen your analysis focus on change of distribution without reordering categories. To set custom fixed order:
1) Open configuration panel, and select Custom categorical order.
2) Enable the "Adjust" dashboard mode, and drag categories using the reordering icon.
The reordering icon (3 small bars) is only visible if the chart uses "custom" category ordering.
Any change you make to the ordering is saved automatically with the dashboard, so you can continue your data exploration later with fixed order, or share dashboards which include the fixed ordering.
To automatically sort categories in alphabetical order, simply choose the Alphabetical option in configurations. Alphabetical ordering also stays fixed as you explore your data.
In any of the modes, you can reverse the current order, which gives you the option to 1) see the least frequent first, 2) use reverse alphabetical order (Z->A), and 3) easily flip your custom order.