WiscIT Widget - Matrix

These widgets are the most complicated in Cherwell, but used appropriately, they can be very informative. The results of a matrix widget is the blending of the search run to get the rows of the matrix and the search used in a column.

New Matrix Widget

The Matrix widget window is divided into two areas, Matrix and Options.

Matrix area

Matrix: The top Matrix area is where the basic settings of the widget are set.
  • Default Title: This is the title used on the matrix when the widget is used in a dashboard. It does not necessarily have to match the contents of the "Name" field at the top of the window.
  • Default Business Object: Use this to decide what Business Object is used by default for the columns of the matrix. The selection of this business object does not limit the business objects that can be used in the columns of the Matrix.
  • Refresh Every [#] [Time Period]: Set the widget to refresh at certain intervals to keep the information up to date if the dashboard is not refreshed in that time period.
  • Allow Drill Down: This option toggles the option to allow drilling down to the results of the searches.
  • Exclude From Filters: This sets the widget to not be affected if a filter is used in a dashboard.
Options area

Options: This is where the the more specific settings of the Matrix are set.

Rows option
  • Rows: This specifies how rows for the matrix are determined.
    • List of Rows Come from a Field: This makes the list of rows come from the field of a business object. When this is selected, the "Field for List of Rows" area appears below the visibility field to make the selections.
    • List of Rows are Based on Date: This makes the list of rows come from a date or date range.
    • Add a Totals Row: Check this box to add up the results in a column and total them in a row at the bottom of the widget.
    • Add an Average Row: Check this box to average the results in a column and show this in a row at the bottom of the widget.
    • Visibility: This decides the visibility of a certain row, decided conditionally by a pre-made or custom expression.
    • Field for List of Rows: This area only appears when the row source is to be determined by a field from a business object.
      • Business Object: Select the Business Object that has the field all the columns need to match.
      • Field: Select the field in the Business Object to be used for the column field to match against.
      • Order By: Select the field in the Business Object to be used for sorting the rows. The checkbox to the right decides if the results should be ordered in ascending or descending order.
      • Limit Rows: Check this box to use a custom or pre-made search to limit what rows appear in the matrix.
    • Limit Values by Date/Date Range: This area appears regardless of the row source (date or field).
      • Range: Limits the row results by a certain date or date range selected from the drop-down field. A new range can be created with the "New" button to the right of the drop-down field.
      • User Selectable: Allows the user of a widget to select the date that limits row results. Choose the user selectable options by clicking the button with an ellipsis.
      • Field Used for Date Range: This appears only when the row source is a Business Object field. Select a date field to use as a reference.
      • Break Range into Periods: This appears only when the row source is a date. Choose the way to group the rows.
Columns option

  • Columns: This area specifies how the columns appear in the matrix. Created columns appear in the large box and can be selected from there. The buttons on the right create, edit, copy, or delete columns. To change the order of the columns, use the arrow button on the bottom-right of the large box.
General New Column Area
    • New/Edit Column: Each column has the same top area with the following fields.
      • Title: This is the title of the column. It appears if a checkbox in the main widget's Appearance area is checked.
      • Fixed Width: Check this box to always have the current column be a certain width.
      • Visible: Check this box to have the column visible in the matrix widget.
    • Numeric Column: This column shows a number that corresponds to the result of the search criteria intersection (the row and the column).
Search ARea
      • Search: This area is where the search for the column is made.
        • Business Object: Choose the Business Object to be associated with the column. If using a field for the rows, make sure the contents of a field in the chosen Business Object can match the field in the row header.
        • Field to Use to Split Approvals Between Rows: Choose the field in the Business Object above that can match the field in the row header.
        • Search Criteria: Use a pre-made or custom search to limit what can appear in the matrix column. See WiscIT - Using the Search Function in Cherwell if necessary.
        • Field Used for Date Range: Choose a field in the Business Object to use when a date filter is used.
Value Area
      • Value: This is where the primary value is selected.
        • Number of Records: This displays a count of the results.
        • Function/Field: Uses a different function (average, minimum, maximum, or total), selected from the dropdown and what field of the Business Object is used for that function.
        • Duration Function: Uses a different function (average, minimum, maximum, or total), selected from the dropdown. It also has areas to select the start time and end time of the desired duration, along with a drop-down box to select the units the column should use.
        • Metric: Select this option to use a Metric value. Select an existing metric from the dropdown. Adjust the selected Metric by clicking on the icon to the right of the dropdown box.
Format Area
      • Format: This area decides how the numeric values should be formatted.
        • Format: Choose the format for the result (number, percent, or currency).
        • Decimal Places: If decimal places are to be used, they can be set here.
        • Text Position: Decide the alignment of the numbers in the column.
        • Color Text: Decides the color of a text depending on a specified expression.
    • Calculated Column: These use a calculation to find the columns value.
Calculated Value Area

      • Calculated Value: Use the triangle in the upper right to find System Functions, Expressions, Stored Values, Metric Values, Counters, or Math Operators to use in the calculation. Other columns can also be used in this calculation.
Format area
      • Format: This area decides how the numeric values should be formatted.
        • Format: Choose the format for the result (number, percent, or currency).
        • Decimal Places: If decimal places are to be used, they can be set here.
        • Text Position: Decide the alignment of the numbers in the column.
        • Color Text: Decides the color of a text depending on a specified expression.
    • Image Column: Use an image to appear according to a certain expression.
Image area
      • Image Width: This specifies the specific width of the image used.
      • Image Height: This specifies the specific height of the image used.
      • Image: Click the expression button to create a custom expression for the column to specify which image appears and when.
    • Text Column: Use text to appear according to a certain expression.
Text area
      • Text: Click the expression button to create a custom expression for the column to specify the text that appears and when.
      • Color Text: Decides the color of the text depending on a specified expression.
    • Value Bar Column: Use bars to show the relative status or level of a calculated value.
Calculated Value
      • Calculated Value: Use the triangle in the upper right to find System Functions, Expressions, Stored Values, Metric Values, Counters, or Math Operators to use in the calculation. Other columns can also be used in this calculation.
Value Line Area
      • Value-Line: This changes the appearance of the value bar.
        • Set Complete Line Based on Largest Value: This sets the maximum value of the bar to the largest value.
        • Set Specific Threshold: This sets the maximum value of the bar to a specific value.
          • Show Values that Exceed the Threshold: Check the box to toggle this feature on and off.
          • Draw a Line to Indicate the Threshold Position: Check the box to toggle this feature on and off.
        • Draw a Border Around the Value-Bar: This shows a border around the entire value bar, regarless of how much the bar is "filled".
        • Colors: This sets the colors of the value bars.
          • Bar Color: This color sets the main color of the value bar. The checkbox below allows the color to be set by a custom expression.
          • Overage Color: This color sets the color of the bar if the level exceeds the specific threshold. The checkbox below allows the color to be set by a custom expression.
          • Use Solid Colors: Check this box to toggle this feature on and off.
        • Fixed Height: This sets a specific height of the value bar that cannot change.
    • Ratings Column: Use images to show a rating to show the relative status or level of a calculated value.
Calculated Value Area
      • Calculated Value: Use the triangle in the upper right to find System Functions, Expressions, Stored Values, Metric Values, Counters, or Math Operators to use in the calculation. Other columns can also be used in this calculation.
Ratings Area
      • Ratings: This changes the appearance of the ratings.
        • Image Width: This specifies the specific width of the image used.
        • Image Height: This specifies the specific height of the image used.
        • Image: Open the Image Manager by clicking the big button to the right of the two parts above. This is how the image used in the ratings can be changed.
        • Image Expression: Click the expression button to create a custom expression for the column to specify which image appears and when.
        • Maximum Rating: This sets a maximum limit to the ratings.
        • Show Partial Ratings: Check this box to toggle this feature on and off.
        • Stretch Image: Check this box to toggle this feature on and off.
Appearance area
  • Appearance: This area controls the appearance of the matrix.
    • Custom Content Font: Check this box and choose the font to use in the matrix.
    • Custom Font Color: Check this box to choose a custom font color.
    • Highlight Alternate Rows: Check this box to have alternate rows be a different color than what is used when the matrix is implemented in a dashboard.
    • Fixed Row Height: Check this box to make the row height fixed, not automatically adjusted based on the row results.
    • Show Column Headers: Check this box to have the Title of the columns to appear in the matrix.



Keywords:Cherwell, row, column, numeric, calculated, image, text, value, rating   Doc ID:46959
Owner:Chris G.Group:WiscIT - Wisconsin IT Service Manager
Created:2015-02-09 11:15 CDTUpdated:2015-05-22 13:49 CDT
Sites:DoIT Help Desk, WiscIT - Wisconsin IT Service Manager
Feedback:  0   0