This walkthrough is split into the following activities:
To create a new report from a sample database:
| 1. | In the main XPAC window, either: |
| 2. | In the Windows Explorer window, navigate to the folder. |
| 3. | Select the file and click . |
| 4. | Click on the Tools toolbar. |
| 6. | Select . The window displays. |
| 7. | Click to open a new report. The window displays. |
| 8. | Select and click . The window displays. |
| 9. | In the tab, select the data fields that you want to include in your report (if required, you can use the standard / functionality to select multiple fields). |
| 10. | In the tab, select from the drop-down list. |
|
To build a simple bar chart display:
| 1. | On the card, select from the drop-down list. |
| 2. | In the pane, expand the dimension to locate the attribute. |
| 3. | Drag & drop the attribute to the shelf. The Y-axis displays years 2000 to 2004 (inclusive) in the . |
| 4. | In the pane, locate the measure. |
| 5. | Drag & drop the measure to the shelf. A horizontal bar graph of the yearly silica grade of fines from 2000 to 2004 (inclusive) displays. |
|
To display a vertical bar graph, click on the analysis reports toolbar.
|
| 6. | If required, define a title for the chart: |
| a. | Click the card where it displays . |
| b. | Type a name for your chart. |
|
To filter and sort data using the toolbars and menu options:
| 1. | In the shelf, right-click the data set and select . The window displays. |
| 2. | Filter the data to include only the top three years: |
| a. | Select in the first drop-down list to display the top results in the data. |
| b. | Select the data set that you want to filter in the second drop-down list (select ). |
| c. | Type in the third field. |
| d. | Click . The bar chart displays only three years (, and ). |
| 4. | Drag & drop the attribute to the shelf to the left of the attribute. The top three years (in terms of the silica grade of fines) display for each bench. |
|
Analysis reports only displays one year of data for some benches. This is because (in this example) the database only holds one year of data for those benches.
|
| 5. | In the shelf, right-click the data set and select . The window displays. |
| 6. | Sort the years as descending in terms of : |
| a. | In the section, select . |
| b. | In the section, select . The drop-down list becomes available. |
| c. | Select the value from the drop-down list. |
The top three years (in terms of the silica grade of fines) for each bench display. The years of data for each bench are sorted in ascending order of the silica grade of fines.
|
To configure display settings:
| 1. | Click on the analysis reports toolbar. Then select either: |
| a. | to display a synopsis of your data in a card on the right of the ; or |
| b. | to display a short description of the analysis you performed on your data. |
| 2. | From the pane, drag & drop to the shelf on the card. A gradient colour legend displays to the right of the . |
| 3. | Double-click the gradient colour legend. The window displays. You can now use the window to change the colour gradient of the bar columns. |
| 4. | Select the bars that represent the highest two years (in terms of the silica grade of fines) for bench . |
|
You can press to select multiple bars.
|
You should see the card update displaying the following data:
If you see different results, check your working in the section on filtering and sorting.
|
Sharing your results
You can share your analysis reports by:
| • | printing your reports by clicking on the analysis reports toolbar. |
| • | pasting your report as an image by clicking on the analysis reports toolbar, then opening the destination program (for example, MS PowerPoint). You can then paste the image of your output from the clipboard. |
