Convert tabular report to chart

The Convert to Chart option in the Actions 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 Actions 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 NetBackup 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 description
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.

Chart description

Each available chart type is described in the table below.

Line Chart
These charts are ideal to view data trends. Usually, the category data is assigned to the horizontal axis and values are assigned to the vertical axis. Data is distributed evenly on both the axes.

Bar Chart

These charts are used compare individual items, either side-by-side or in a stacked manner. Typically, the category data is assigned to the vertical axis, while numeric data values are plotted evenly on the horizontal axis.

Bar and Line Combo Chart
These charts are used for easier data representation by combining bar and line charts. One set of data is displayed in a series of bars while the other is represented as a line.
Pie Chart:
The portions displayed are in proportion to the sum of the values of the selected field and are represented as percentage. Ensure you do not have zero or negative data values while using a pie chart.
Area Chart
This chart is used to highlight the total value across a trend. It shows the relationship of the sum of one part of the plotted values to the whole. You can also view this chart in stacked form.

Donut Chart

The portions displayed are in proportion to the sum of the values of the selected field and are represented as percentage. Ensure you do not have zero or negative data values while using a donut chart.

Solid Gauge Chart

This chart is used to compare two values of the same category, such as total storage against consumed or free storage. The chart displays a comparison of the sum of values from one column against the other.

Convert tabular report to chart

Feedback

Feedback