Introduction
In this tutorial, we will walk through setting up an append sub query in order to compare two years worth of figures.
...
This will mean that we have Country as a common field for 2014 and 2013 so this will form our join when we add the Append.
Note: sometimes you will have a case where you don't wish to filter the Country list by 2014, this may be because some countries have no results for 2014 yet. In this case you would have Country in the Master Query, and an Append Query for each Invoiced Amount.
...
This will be joined to the Master Query using the Athlete Country field. The query will be filtered by Year = 2013, and will include a copy of the Sum Invoiced Amount field to be filtered.
Initialise
| セクション |
|---|
| 列 |
|---|
| 1. Click on the Create link and select Report to begin building your report. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 2. You should now be on the Initialise Report page. Select the Drag and Drop Builder as the build tool. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 3. Select Ski Team as the View. |
| 列 |
|---|
|  Image Modified
|
|
Master Query
| セクション |
|---|
| 列 |
|---|
| 4. Drag and drop the  Image Modified Athelte Country dimension and  Image Modified Invoiced Amount metric into the Columns list. 5. Drag and drop the Image Modified Year dimension into the Filters list. |
| 列 |
|---|
|  Image Modified
|
|
Append Query
Create Append
...
| セクション |
|---|
| 列 |
|---|
| 22. Click on the x on the filter panel to close it. Be sure not to click on the X to close the report builder. |
| 列 |
|---|
| 
|
|
Formatting
| セクション |
|---|
| 列 |
|---|
| 23. Click on the first Sum Invoiced Amount field's drop down list and select Format. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 24. Change the Display name to Invoiced 2014. It's important to do this to provide the user with some context to help differentiate between the queries. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 25. While still in the Column Formatting menu, select the Sum Invoiced Amount field from the list on the left. 26. Set the name to Invoiced 2013 and close the menu. |
| 列 |
|---|
|  Image Modified
|
|
Save
| セクション |
|---|
| 列 |
|---|
| 27. Click Report > Save to activate your report. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 28. Set the Name of your report to Append Sub Query Tutorial. 29. Set the Description to This report was written using the Sub Query Tutorial. 30. Select Tutorial as the Category. 31. Select Training as the Sub Category. 32. Click Activate to finish. |
| 列 |
|---|
|  Image Modified
|
|
| セクション |
|---|
| 列 |
|---|
| 33. You now have an active Append Sub Query report. |
| 列 |
|---|
|  Image Modified
|
|