Learn to use dashboarding tools that make multidimensional data simple to view. One of the useful input controls is the spinner. It let's a user select discrete values in a specified range for faster, pre-determined data exploration. View the example below to learn more about the Style Intelligence solution.
In this example, you will use a Spinner control to display only values in a table that exceed the specified Spinner value.
1. Create a new Worksheet.
2. In the following steps, add a new Embedded Table containing a single numeric data cell:
a. Click the ‘New Object’ button on the toolbar, and select ‘Embedded Table’.
b. Drag across the Worksheet grid to select three vertical cells, and release.
This creates a new Embedded Table named ‘Query’, with just one data cell.
|#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index
c. Double-click the column header cell (‘col0’), and change the name to “Quantity”.
d. In the data cell of the Embedded Table, enter the value “4000.”
e. Right-click the column header cell (‘Quantity’), and select ‘Column Type’ from the context menu. This opens the ‘Column Type’ dialog box.
f. In the ‘Column Type’ dialog box, set ‘Type’ to ‘Integer’. Click ‘OK’.
3. Expand the ‘Orders’ data source on the Asset tree, and drag the ‘Sales by Category’ table onto the Worksheet. This creates a new table called ‘Sales by Category’.
4. In the following steps, join the Embedded Table to the ‘Sales by Category’ table. The tables will be joined on the ‘Qty Sold’ column using an inequality join condition:
a. Select both of the tables (Shift-click).
b. Click the ‘Join Table’ button on the toolbar, and select ‘Inner Join’. This opens the ‘Inner Join’ dialog box.
c. On the left side (‘Query’), select ‘[Quantity]’ from the top menu.
d. On the right side (‘Sales by Category’), select ‘[Qty Sold]’ form the top menu.
e. From the center menu (comparison operator), select ‘<=’, as shown below
The tables are now joined on the ‘Qty Sold’ column, creating a new table called ‘Query1’. The values shown in the ‘Qty Sold’ column of joined table ‘Query1’ will only be those which equal or exceed the ‘Quantity’ value in the Embedded Table.
5. Verify that the joined table is filtered correctly:
a. Click the ‘Show Live Data’ button in the toolbar of the ‘Query1’ table, and expand it to show all the data. (Only values of ‘Qty Sold’ greater than or equal to 4000 are shown.)
b. Expand the Embedded Table (double click the title bar). Enter “6000” as the value, and observe how the data in table ‘Query1’ is filtered accordingly.