...
5.Group transactions by the first three characters of the postal code
In the Actions menu, select: "Format> Format> Control Break command".
This function is used to break a column of a report. For our example, group the transactions by the first three characters of the postal code.
Under the "Column" field, select the column entitled "** 3 first char. Of the postal code"
Click on the Apply button. The report is regenerated immediately by grouping the transactions by the first 3 characters of the postal code.
...
6.Calculate the average of the days elapsed based on the first three characters of the postal codes.
In the Actions menu, select: "Format> Aggregate".
This function is used to perform sums, average, maximum, median, etc. from a numeric or currency column in a report. For our example, calculate the average of the days elapsed for each of the postal code groupings.
Under the "Function" field, select: "Average".
Under the "Column" field, select: "** Nb days".
Click on the Apply button. The report is regenerated immediately by adding to the last line of each of our groupings by postal code, the average number of days elapsed between the listing and the sale.
...
7.Save Save your personalized interactive report
If you want to reuse your personalized report, you can just save it.
In the Actions menu, select: Save report and enter a representative name (the description is optional).
You can reuse it at any time by going back to "Modules> Transactions> Desktop> Detail button" and clicking on the "Reports" drop-down list. Your report appears at the bottom of the list in Private Reports.
Your first interactive report is over!
CONVERT THE RESULT TO A GRAPH
As it seems heavy to me to go through each of the pages to know the average number of days per postal code, nothing better than to represent in a graphic form the result of my work.
In the Actions menu, select: "Format> Chart".
This function allows you to easily represent in graphic form, 2 data of my report with a function.
Type of graphic: horizontal or vertical stick
Under the "Caption" field, select: "** First 3 char. Of the postal code", Axis title for the caption: "Postal code".
Under the "Value" field, select: "** Nb days", Axis title for the value: "Days".
Under the "Function" field, select: "Average".
Under the "Sort" field, select: "Value - Descending".
Click on the Apply button. The graph is generated immediately
...
You can at any time click on the 2nd button to the left of the Actions menu to return to the list and at any time click on the 1st button to the left of the Actions menu to return to the graph.
...
It is possible that there is not a value on the axis for each of the rods. To display the number of days versus a postal code; you just have to hover the mouse pointer over the stick and you will have the postal code and the average of the corresponding number of days.
Modify the chart
To modify the layout or sorting of the chart, all you have to do is click on the "Edit chart" link which is located among the filters.
If you want to have the same statistic but by city instead of the postal code, it's simple; Just click on the link "Edit chart"
...
Select, under "Label", "City" (Change the title of the label to "City").
Click on the Apply button. The graph is regenerated immediately but displays the average number of days per city instead of the first 3 characters of the postal code.
| Tip |
|---|
Congratulations! You have made your first interactive report! |