mrc Documentation
http://www.mrc-productivity.com/
|
|
The Grouping Function in Report Graphs
The
grouping functionality consists of three key components: the value, the descriptor,
and the group. The graph value denotes what values will be graphed. The
descriptor field denotes how data will be separated. Lastly, the group fields
denote how a field will be grouped.
To utilize
this functionality, click on your graph through m-Painter and click the “Edit
Graph” icon. Next, select the “Image Data Collection” tab.
Let’s say I
have a revenue field (SREVS), a year field (YRTL), and a product field
(PRODNO). For this example, I will group by the product field.
By default,
the graph is set to graph the grand total line, however, I would like to graph
the detail lines. Select the appropriate fields from the drop down on the
right, be sure Detail Level is selected, and click “Add” for the fields you
wish to graph.
Next, I
would like to separate the data out by the different years. In the “Graph Value
Descriptions” enter the appropriate substitution code – in our case
F_V_TN_[YRTL]. Lastly, I want the data set grouped by the Product Number.
Overall, the idea here is that we will graph the value of revenue and it will
be separated by year, and grouped by Product Number. Remember, the substitution
code of F_V_TN tells mrc that your data is coming from the detail line.
Note: The
only other thing you will need to do is move the Data Collection Icon from the
Grand Total Line to the Detail Line. Save your painting. When you run the
application you will see the following data:
