Creating a tabular chart
Use a tabular chart when you have more than one set of values that have a direct relationship.
Before you begin
Procedure
- In the Views section of the widget, give the chart a name and select whether to show the title and the update status.
- Select Tabular Display.
- On the General tab, set the following properties:
- Select all columns or specify which columns to display.
- If you selected all columns, you can configure different settings in the Columns settings menu.
- If you selected specific columns, click More options for each column and give the column a name to display. You can also set the following options: specify the column alignment or use the alignment that is inherited from the default column settings; specify the data format as none (no formatting is applied), date, date and time, or number (the latter formats use the locale default formatting); specify the column width either in pixels or as a percentage of the width of the chart.
- For both column options, you can modify the data format that you want to display in your tabular chart and add decorators that indicate the type of data. If you select an Enriched data format, then you can configure a severity icon that precedes the data.
- Select the default alignment for all of the columns in the table.
- Select a table size and the maximum number of items to display.
- On the Thresholds tab, set thresholds to display conditional color
formatting in the chart.
- Click Add Threshold Indicator.
- Set thresholds to display any numerical field in the query, such as the magnitude of events. Select the threshold indicator (color, shape, or both) and then select the column.
- If you selected color, enter a value and then click Add Value to pick a color or enter an HTML color code in the color palette to make it easier to select the same colors on different charts.
- If you selected a shape, enter a value and then click Add Value
to pick a shape. If you select color and shape threshold indicators, color is applied to the shape instead of the left border of the table. For example, a caution state can be displayed as a yellow triangle. You can use the same threshold values for color and shape.Run the query to get results and check your threshold settings to make sure that they work properly. It is invalid to select a non-numerical column as a threshold.
- Optional: On the Drilldown tab, choose an action for
when a row is clicked in the tabular chart. You can open a dashboard or a URL.
- If you chose to open a dashboard, select the dashboard to open, optionally select
dashboard parameter values, and choose whether to open it in the current window or in a new
window.
If you set parameters, they are passed to the target dashboard based on the row that was clicked in the tabular chart. For example, if you set an ID parameter, the bar or segment ID is passed as a parameter to the target dashboard. If you set a dashboard parameter value to Default, no parameter value is passed to the target dashboard; the existing session or default parameter value is used or the parameter field is blank in the target dashboard Parameters card.
Tip: If you drill down to a different dashboard in the same window, you can use the breadcrumb trail to return to previous dashboards in the drill path. - If you chose to open a URL, specify an absolute path to open an external URL (for
example, https://www.ibm.com). Choose
whether to open the URL in the current window or in a new window. If you open an external URL in the
current window, it replaces the console.
You can define any number of parameters anywhere in the URL. Enclose parameters in braces ({}), then select a value for each parameter. For example,
https://exchange.xforce.ibmcloud.com/ip/{ip_address}
. - If you chose to open a panel, select the drill down column and enrichment type.
For example, if the selected drill down column represents a source IP address, then select Enriched IPv4 as the enrichment type, so the panel opens with the details and enrichment for this IP address.
- If you chose to open a dashboard, select the dashboard to open, optionally select
dashboard parameter values, and choose whether to open it in the current window or in a new
window.
- Preview how the chart looks and then click Save.
Tip: The labels for the chart come from the queries that are used. If they are unintelligible in the preview, edit the labels in the View section.