InetSoft Product How-To: Dashboard Software - Creating a Dashboard Column

Creating a dashboard column that presents data in a simple and concise way is easier than ever before using InetSoft's award-winning dashboard software. View the example below to learn more about the Style Intelligence solution.

A numeric range column groups numeric data into a predefined set of bins or ranges, for example:

  -Less than 5
  -5 to 10
  -10 to 15
  -15 to 20
  -Greater than 20

You can create a range column for any numeric column in a Data Table. To create a range column, follow these steps:

  1. Right-click the header of the column for which you want to create a range column, and select the    'New Range Column' option from the context menu. This opens the 'Value Range Name' dialog box

  2. Enter a name for the new range column, and click 'OK'. This opens the 'Numeric Range Option'    dialog box. Here you can specify the different benchmarks defining the range.

To customize a bench¬mark label, double-click the benchmark value to enable editing.

creating a dashboard column


demo icon
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

  3. Enter a benchmark value into the 'Value Range' field, and click the 'Add' button. Repeat until all desired benchmarks have been entered.

  4. Select the 'Less Than Min' checkbox to create a bin for all values that fall below the minimum benchmark. If you do not select this option, those values are classified as “Others.”

  5. Select the 'Greater Than Max' checkbox to create a bin for all values that fall above the maximum benchmark. If you do not select this option, those values are classified as    “Others.”

  6. Click the 'OK' button to close the dialog box.

A date range column groups dates into a fixed set of date bins. You can create a range column for any date column in a Data Table.

To create a range column, follow these steps:

  1. Right-click the header of the column for which you want to create a range column, and select the 'New Range Column' option from the context menu. This opens the 'Date Range    Name' dialog box.

  2. Enter a name for the new column in the 'Date Range Name' dialog box, and click 'OK'. This opens the 'Date Range Option' dialog box.

  3. Select the desired partitioning (year, month, quarter, etc.), and click the 'OK' button to close the dialog box.

Previous: Embedded Dashboard Commands