Convert tabular report to chart
The option in the menu enables you to view the data from a tabular report in a chart form. This feature helps you to visualize tabular data in different chart forms and view the data patterns. You can save the charts separately under My Reports folder and also revert back to the original tabular report through the same menu. Once you save the chart, you can share or email it like other reports.
To convert a tabular report to a chart:
- Login to the IT Analytics Portal and generate a tabular report. You can navigate to your report from the Reports tab or use the Search to generate the report.
- After generating the tabular report, go to Actions menu > Convert to Chart.
- On the Report Converter pop-up, choose the chart type and other data sources based on the descriptions in the table below:
Field name
Description
Display as
Select a chart to display from the list:
Line Chart
Bar Chart
Bar and Line Combo Chart
Area Chart
Pie Chart
Donut Chart
Solid Gauge Chart
Chart type
Choose between:
Simple: Displays a simple plot of data points.
Pivot: Displays a plot of data points specific to each category.
This option helps you to summarize data based on a specific category. Pivot charts can help you analyze data trends specific to the pivoted category and present meaningful insights.
Category
Appears when you choose to view a Pivot chart.
Specify the column name based on which you wish to categorize the data displayed on your chart..
Horizontal axis
Specify the column name that must appear on the horizontal axis.
Vertical axis
Appears when you choose to view a Pivot chart.
Specify the column name that must appear on the vertical axis.
Line
Specify the column name of the data points that must appear against the horizontal axis.
Bar
Appears when you select a Bar Chart. Specify the column name of the data points that you want to view as bars on the chart.
You can use the + and - to add or remove data points on the chart.
Stack bars
Displays stacked bars on the chart.
Area
Appears when you select an Area Chart. Specify the column name of the data points that must appear as the shaded area on the chart.
You can use the + and - to add or remove data points on the chart.
Stack areas
Select to stack the plotted areas on the chart.
Portion
Specify the column name that you want to view as pie or donut portions.
Value
Appears only for a Solid Gauge Chart.
Specify the column name of the data points that will appear as gauge
Max value
Appears for a Solid Gauge Chart.
Specify the column that will denote the maximum value of the gauge.
Preview
Click to preview your chart before the report is actually converted to the chart.
- Click OK to view your chart.
The tabular report is converted to a chart. You can save this chart under the My Reports folder.
Each available chart type is described in the table below.
Line Chart
Bar Chart
Bar and Line Combo Chart
Pie Chart:
Area Chart
Donut Chart
Solid Gauge Chart
