Charting query results as a tower chart
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.
- 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:
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.