Guidelines

How do I sort a cross table in Spotfire?

How do I sort a cross table in Spotfire?

Click the header of the cross table column or row that contains the values you want to sort. In the opened menu, beneath Sorting, click to sort from lower to higher values, or click to sort the from higher to lower values.

How do I sort data in Spotfire?

Go to the Sort Order tab. Click on the Custom Sort Order radio button, then click on “Configure…”. Select the values and then use the buttons to reorder the values (move up, move down, move first, move last), reverse the order, or reset the order to the default.

What is a cross table in Spotfire?

A cross table is a two-way table consisting of columns and rows. It can also display subtotals for columns, or show images on the horizontal or vertical axis. Note: The aggregated value for subtotals and grand totals is not calculated on the values shown in the cross table, but on the underlying row values.

What is IronPython in Spotfire?

IronPython Scripting in TIBCO Spotfire® Scripts can be exctuted from action controls in the Text Area, from the Graphical Table or the KPI Chart or be triggered by Document Property changes. To create an analyses containing IronPython scripts, the analyst needs the Author Scripts license function.

How do I rearrange columns in Spotfire?

Click Separator, and then enter a forward slash (/) in the field. Click Reorder to reorder the target columns. In the Reorder Columns dialog, drag the split columns to reorder according to the M/d/yyyy format. Click OK.

How do I sort a category axis in Spotfire?

Procedure

1. Place the cursor on the Category axis. The axis is highlighted.
2. Click the highlighted area to access a pop-up menu.
3. Select Sort bars by value. Tip: If you want to sort the bars from the lowest to the highest bar, select Reverse scale after clicking Sort bars by value.

What is a cross tab table?

A crosstab is a table showing the relationship between two or more variables. Where the table only shows the relationship between two categorical variables, a crosstab is also known as a contingency table.

What does cross tabulation tell you?

Cross tabulation is a method to quantitatively analyze the relationship between multiple variables. It also shows how correlations change from one variable grouping to another. It is usually used in statistical analysis to find patterns, trends, and probabilities within raw data.

How do I write a script in Spotfire?

Creating scripts

1. Edit any text area, and click on the Insert Action Control icon:
2. Choose Button or Link, enter the text you want to display on the button or link under Display text:, select the Script icon, and click on New… to begin writing your script.

How do I sort data in an Excel chart?

Here’s how you can sort data tables in Microsoft Excel:

1. Highlight your table. You can see which rows I highlighted in the screenshot below.
2. Head to the Data tab.
3. Click the Sort icon.
4. You can sort either column. To arrange your bar chart from greatest to least, you sort the # of votes column from largest to smallest.

Why is cross tabulation used?

Cross tabulation is used to quantitatively analyze the relationship between multiple variables. By showing how correlations change from one group of variables to another, cross tabulation allows for the identification of patterns, trends, and probabilities within data sets.

How to sort a cross table visualization in TIBCO Spotfire?

Below is a sample script on how to sort the cross table visualization. # Copyright © 2017.

How to sort columns in the Spotfire IronPython?

Sort columns ascending or descending: myVis.SortColumnsOrder = SortOrder.Ascending # OR myVis.SortColumnsOrder = SortOrder.Descending # 3. Show only the first number of columns: myVis.ShowTopNColumns = True # Set the first number of columns to show: myVis.TopNRowCount = 5 # 4.

When to use custom sort order in Spotfire?

This is particularly useful when you want to order the bars in a bar chart by something other than a numerical value (or by size). It is also useful where the set of possible values for the custom sort order is not known during the authoring of a Spotfire file.

How to update cross plot properties in Spotfire?

The IronPython script below shows how to update any of the cross plot properties associated with row sorting. In order from top to bottom in the user interface, this includes: from Spotfire.Dxp.Application.Visuals import * from Spotfire.Dxp.Data import SortOrder myVis = myVis.As [Visualization] () # 1.