You can chart your query results as a tower chart by using QMF Analytics for TSO.
About this task
Tower charts show the frequency of data items in successive
numerical intervals of equal size, or to show a comparison of categorical
values in a query result.
QMF Analytics for TSO will
plot data distributions or simple categorical values depending on
the type of data in column to be used as the x-axis on the chart. QMF Analytics for TSO examines
the X variable data type, data values, and number of rows before deciding
whether to chart it as a distribution or as a set of categorical values.
In
this example you will chart salary by department number. You might
want to chart this type of data to understand which departments in
a company have the highest cost.
Procedure
Start QMF for TSO.
Your QMF administrator
can tell you how to start a QMF session
and give you a user ID. Check with your QMF administrator
if you have any questions about getting started with QMF.
From the QMF Home Panel, enter DISPLAY
Q.STAFF on the command line and press Enter.
QMF for TSO displays
the query result as a multi-columned report.
Enter SHOW ANALYTICS on the
command line and press Enter to start QMF Analytics for TSO.
Tab to Tower in the Charts section
of the QMF Analytics for TSO Home
Panel and press Enter.
The Parameter Selection panel
is displayed.
Create the specification for your analysis.
Set your parameters as shown in the following
table.
You can enter column names manually or you can tab
to the field and press the List function key (F4).
The List function opens a Column Selection window
that lists all of the column names from the query result. To select
a column from the Column Selection window, tab
to the column name and press Enter. QMF Analytics for TSO adds the
name to the Parameter Selection panel automatically.
Table 1. Parameter Settings for Tower chart
Parameter
Setting
Specify the columns to form the vertical coordinates
(y-axis)
SALARY
Specify the column to form the horizontal coordinates
(x-axis)
DEPT
Tabulation?
No
Chart Title
Enter a title for your chart in the Chart
Title field or accept the default value of asterisk (*).
If you accept the default value of asterisk
(*), QMF Analytics for TSO creates a title based on the columns that
you have selected.
If you delete the asterisk (*) and leave
this field blank, the analysis output will not include a title.
Optional: Press the Save function key (F5)
to save the specification to the QMF database
as an ANALYTIC object.
Saving the specification to the database allows
you to run your analysis directly from the QMF command line at a later
time, without having to navigate to the QMF Analytics for TSO Home
panel and reenter the parameters. Saving specifications makes sense
if you plan on running the analysis frequently or multiple times.
Note: The
global variable DSQEC_SESSGLV_SAV in QMF controls
how the autosave for parameter settings works. For information about
Global Variables, see Global Variable List in the QMF
help.
Press the Run function key (F2) to generate the chart.
QMF Analytics for TSO generates
the following chart:
Figure 2. Salary by Department
Tower Chart
The chart shows that the accumulated salary by department.
It shows that department 10 is the costliest in terms of employee
salary and department 66 as the least costly in terms of employee
salary.
Optional: If you have configured print capabilities
in QMF, you can print the chart.
Press the End function key (F3) to return to the Parameter
Selection panel.
Press the End function key (F3) to return to the QMF Analytics for TSO Home
panel.
