Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Oct 19, 2016

Sort Category By...

The default sort for categorical data is alphabetical - sometimes we need to order by a hidden sequencer instead.

In the current product we can achieve it by a custom sort - but this is only useful for static category data.

For dynamic category data there is no way to do it in standard Spotfire - so we keep having to create python scripts and clever loading utilities. It's such a small thing, and so common, we really feel it should be part of the product.

Basically: "Sort by..." is available in the category axis property window, defaults to the same field as the display category, but can be changed to any field or expression.

  • Attach files
  • Admin
    Niklas Amberntsson
    Reply
    |
    Jun 24, 2020

    Hi Hector, I just wanted to link the issues together, but pasted it in the wrong place.

  • Guest
    Reply
    |
    Jun 24, 2020

    Niklas,

    I don’t understand your post. It is a link to another person’s question with the same request.

  • Guest
    Reply
    |
    Jan 10, 2017

    This is really important. You can do this in most other apps, like SQL Server Reporting Services, ASPxPivotGrid, etc. Not being able to do this leads to some ugly looking analyses that have numbers prepended to value names everywhere. Looks particularly bad on a cross-tab with numbered columns.

26 MERGED

Sort bars by value from custom expression

Merged
Currently when sorting bars by value in a bar chart, the sorting is based on the total bar value. Please add an option to customize the value to sort on. Example: I've a barchart with on the category axis different customers. On the value axis I'...
about 8 years ago in Spotfire / Visualization 0 Future Consideration
1 MERGED

Sorting bar charts and pivot tables based on other columns

Merged
Currently sorting the bars or columns/rows of bar charts resp. pivot tables can be done based on values in the chart. Very helpful. But could the sorting also be based on columns that are not in the chart? This would give us extra understanding of...
almost 6 years ago in Spotfire / Visualization 0 Future Consideration
2 MERGED

Sorting in X-axis of BoxPlot

Merged
Hi, We want to sort X-axis by column or statistic item without adding column or statistics in X-axis. Regards,
almost 8 years ago in Spotfire / Visualization 0 Future Consideration
1 MERGED

UX: Sort Orders for Individual Charts

Merged
Having the Column Sort Order visible in Data Panel is helpful for categorical data types. It may be good to allow users to change sort order per visualization as well (not just Table Visualizations).
about 6 years ago in Spotfire / Visualization 0 Future Consideration
17 MERGED

Sort X-axis by other column

Merged
Sort x axis by column not on x axis similar to color by different column name
almost 9 years ago in Spotfire / Visualization 0 Future Consideration
2 MERGED

Select measure to sort by in trellis

Merged
When you trellis a bar chart by measures (column names), the visualization is sorted by a combination of the two measures (thats what it looks like - don't know for sure :)). It would be really useful to have a possibility to select which measure...
almost 8 years ago in Spotfire / Visualization 0 Future Consideration