Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/matomo-org/matomo.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordiosmosis <benaka@piwik.pro>2014-09-21 00:14:13 +0400
committerdiosmosis <benaka@piwik.pro>2014-09-21 03:02:40 +0400
commit8d0205e32a430d4bb028ec14877ff7a7d7b5d22e (patch)
treec0af7e79f9cd11b0e34006b5a3bdae2e0f0aee22 /tests/PHPUnit/Integration/expected
parentb1968947d69b0da7bfc8c2eea6c8311c3b6be433 (diff)
Refs #6078, order pivot table columns by sum, descending and aggregate cut-off columns into 'Others' column.
Diffstat (limited to 'tests/PHPUnit/Integration/expected')
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml12
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml12
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml12
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csvbin440 -> 440 bytes
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json2
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml130
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml12
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml48
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml48
9 files changed, 138 insertions, 138 deletions
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
index a60b9519fb..744fcf397e 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
@@ -6,39 +6,39 @@
<result date="2010-01-03">
<row>
<col name="label">this search term</col>
- <col name="Melbourne, Victoria, Australia">2</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Melbourne, Victoria, Australia">2</col>
</row>
<row>
<col name="label">search term 2</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">2</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">search term 3</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">2</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">search term 4</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">2</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">that search term</col>
- <col name="Melbourne, Victoria, Australia">2</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">2</col>
</row>
<row>
<col name="label">search term 1</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
</result>
<result date="2010-01-04" />
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
index 777020b15e..05553ef4f8 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
@@ -2,32 +2,32 @@
<result>
<row>
<label>this search term</label>
- <Bing>0</Bing>
<Google>1</Google>
+ <Bing>0</Bing>
</row>
<row>
<label>search term 2</label>
- <Bing>0</Bing>
<Google>0</Google>
+ <Bing>0</Bing>
</row>
<row>
<label>search term 3</label>
- <Bing>0</Bing>
<Google>1</Google>
+ <Bing>0</Bing>
</row>
<row>
<label>search term 4</label>
- <Bing>1</Bing>
<Google>0</Google>
+ <Bing>1</Bing>
</row>
<row>
<label>that search term</label>
- <Bing>0</Bing>
<Google>1</Google>
+ <Bing>0</Bing>
</row>
<row>
<label>search term 1</label>
- <Bing>1</Bing>
<Google>0</Google>
+ <Bing>1</Bing>
</row>
</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml
index 70bcfeed7d..4635e78f76 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml
@@ -3,31 +3,31 @@
<row>
<col name="label">this search term</col>
<col name="Toronto, Ontario, Canada">0</col>
- <col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Others">3</col>
</row>
<row>
<col name="label">search term 2</col>
<col name="Toronto, Ontario, Canada">0</col>
- <col name="Yokohama, Kanagawa, Japan">2</col>
+ <col name="Others">2</col>
</row>
<row>
<col name="label">search term 3</col>
<col name="Toronto, Ontario, Canada">2</col>
- <col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Others">0</col>
</row>
<row>
<col name="label">search term 4</col>
<col name="Toronto, Ontario, Canada">2</col>
- <col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Others">0</col>
</row>
<row>
<col name="label">that search term</col>
<col name="Toronto, Ontario, Canada">0</col>
- <col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Others">2</col>
</row>
<row>
<col name="label">search term 1</col>
<col name="Toronto, Ontario, Canada">0</col>
- <col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Others">1</col>
</row>
</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv
index 9b91feb5ee..0536708ea8 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv
Binary files differ
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json
index 3ffebb1d65..9b82ca037a 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json
@@ -1 +1 @@
-[{"label":"this search term","Melbourne, Victoria, Australia":2,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1},{"label":"search term 2","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":2},{"label":"search term 3","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false},{"label":"search term 4","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false},{"label":"that search term","Melbourne, Victoria, Australia":2,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":false},{"label":"search term 1","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1}] \ No newline at end of file
+[{"label":"this search term","Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1,"Melbourne, Victoria, Australia":2},{"label":"search term 2","Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":2,"Melbourne, Victoria, Australia":false},{"label":"search term 3","Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false,"Melbourne, Victoria, Australia":false},{"label":"search term 4","Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false,"Melbourne, Victoria, Australia":false},{"label":"that search term","Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":false,"Melbourne, Victoria, Australia":2},{"label":"search term 1","Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1,"Melbourne, Victoria, Australia":false}] \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
index 45bd7630ea..5697f732c4 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
@@ -2,122 +2,122 @@
<result>
<row>
<col name="label">0</col>
- <col name="/0">1</col>
- <col name="/1">1</col>
- <col name="/10">0</col>
- <col name="/11">0</col>
- <col name="/12">0</col>
- <col name="/13">0</col>
+ <col name="/index">1</col>
<col name="/14">0</col>
+ <col name="/13">0</col>
+ <col name="/12">0</col>
+ <col name="/11">0</col>
<col name="/15">0</col>
<col name="/16">0</col>
- <col name="/17">0</col>
- <col name="/18">0</col>
<col name="/19">0</col>
- <col name="/2">1</col>
+ <col name="/18">0</col>
+ <col name="/17">0</col>
+ <col name="/10">0</col>
+ <col name="/9">0</col>
<col name="/3">1</col>
+ <col name="/2">1</col>
+ <col name="/1">1</col>
<col name="/4">0</col>
<col name="/5">0</col>
- <col name="/6">0</col>
- <col name="/7">0</col>
<col name="/8">0</col>
- <col name="/9">0</col>
- <col name="/index">1</col>
+ <col name="/7">0</col>
+ <col name="/6">0</col>
+ <col name="/0">1</col>
</row>
<row>
<col name="label">1</col>
- <col name="/0">0</col>
- <col name="/1">0</col>
- <col name="/10">0</col>
- <col name="/11">0</col>
- <col name="/12">0</col>
- <col name="/13">0</col>
+ <col name="/index">1</col>
<col name="/14">0</col>
+ <col name="/13">0</col>
+ <col name="/12">0</col>
+ <col name="/11">0</col>
<col name="/15">0</col>
<col name="/16">0</col>
- <col name="/17">0</col>
- <col name="/18">0</col>
<col name="/19">0</col>
- <col name="/2">0</col>
+ <col name="/18">0</col>
+ <col name="/17">0</col>
+ <col name="/10">0</col>
+ <col name="/9">0</col>
<col name="/3">0</col>
+ <col name="/2">0</col>
+ <col name="/1">0</col>
<col name="/4">1</col>
<col name="/5">1</col>
- <col name="/6">1</col>
- <col name="/7">1</col>
<col name="/8">0</col>
- <col name="/9">0</col>
- <col name="/index">1</col>
+ <col name="/7">1</col>
+ <col name="/6">1</col>
+ <col name="/0">0</col>
</row>
<row>
<col name="label">2</col>
- <col name="/0">0</col>
- <col name="/1">0</col>
- <col name="/10">1</col>
- <col name="/11">1</col>
- <col name="/12">0</col>
- <col name="/13">0</col>
+ <col name="/index">1</col>
<col name="/14">0</col>
+ <col name="/13">0</col>
+ <col name="/12">0</col>
+ <col name="/11">1</col>
<col name="/15">0</col>
<col name="/16">0</col>
- <col name="/17">0</col>
- <col name="/18">0</col>
<col name="/19">0</col>
- <col name="/2">0</col>
+ <col name="/18">0</col>
+ <col name="/17">0</col>
+ <col name="/10">1</col>
+ <col name="/9">1</col>
<col name="/3">0</col>
+ <col name="/2">0</col>
+ <col name="/1">0</col>
<col name="/4">0</col>
<col name="/5">0</col>
- <col name="/6">0</col>
- <col name="/7">0</col>
<col name="/8">1</col>
- <col name="/9">1</col>
- <col name="/index">1</col>
+ <col name="/7">0</col>
+ <col name="/6">0</col>
+ <col name="/0">0</col>
</row>
<row>
<col name="label">3</col>
- <col name="/0">0</col>
- <col name="/1">0</col>
- <col name="/10">0</col>
- <col name="/11">0</col>
- <col name="/12">1</col>
- <col name="/13">1</col>
+ <col name="/index">1</col>
<col name="/14">1</col>
+ <col name="/13">1</col>
+ <col name="/12">1</col>
+ <col name="/11">0</col>
<col name="/15">1</col>
<col name="/16">0</col>
- <col name="/17">0</col>
- <col name="/18">0</col>
<col name="/19">0</col>
- <col name="/2">0</col>
+ <col name="/18">0</col>
+ <col name="/17">0</col>
+ <col name="/10">0</col>
+ <col name="/9">0</col>
<col name="/3">0</col>
+ <col name="/2">0</col>
+ <col name="/1">0</col>
<col name="/4">0</col>
<col name="/5">0</col>
- <col name="/6">0</col>
- <col name="/7">0</col>
<col name="/8">0</col>
- <col name="/9">0</col>
- <col name="/index">1</col>
+ <col name="/7">0</col>
+ <col name="/6">0</col>
+ <col name="/0">0</col>
</row>
<row>
<col name="label">4</col>
- <col name="/0">0</col>
- <col name="/1">0</col>
- <col name="/10">0</col>
- <col name="/11">0</col>
- <col name="/12">0</col>
- <col name="/13">0</col>
+ <col name="/index">1</col>
<col name="/14">0</col>
+ <col name="/13">0</col>
+ <col name="/12">0</col>
+ <col name="/11">0</col>
<col name="/15">0</col>
<col name="/16">1</col>
- <col name="/17">1</col>
- <col name="/18">1</col>
<col name="/19">1</col>
- <col name="/2">0</col>
+ <col name="/18">1</col>
+ <col name="/17">1</col>
+ <col name="/10">0</col>
+ <col name="/9">0</col>
<col name="/3">0</col>
+ <col name="/2">0</col>
+ <col name="/1">0</col>
<col name="/4">0</col>
<col name="/5">0</col>
- <col name="/6">0</col>
- <col name="/7">0</col>
<col name="/8">0</col>
- <col name="/9">0</col>
- <col name="/index">1</col>
+ <col name="/7">0</col>
+ <col name="/6">0</col>
+ <col name="/0">0</col>
</row>
</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
index 99086f82e8..c6315c7326 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -2,38 +2,38 @@
<result>
<row>
<col name="label">this search term</col>
- <col name="Melbourne, Victoria, Australia">2</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Melbourne, Victoria, Australia">2</col>
</row>
<row>
<col name="label">search term 2</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">2</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">search term 3</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">2</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">search term 4</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">2</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
<row>
<col name="label">that search term</col>
- <col name="Melbourne, Victoria, Australia">2</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">0</col>
+ <col name="Melbourne, Victoria, Australia">2</col>
</row>
<row>
<col name="label">search term 1</col>
- <col name="Melbourne, Victoria, Australia">0</col>
<col name="Toronto, Ontario, Canada">0</col>
<col name="Yokohama, Kanagawa, Japan">1</col>
+ <col name="Melbourne, Victoria, Australia">0</col>
</row>
</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
index 4c9fe03b6f..1adf9d722a 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
@@ -2,56 +2,56 @@
<result>
<row>
<col name="label">this search term</col>
- <col name="Alexa">0</col>
- <col name="Ask">1</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 2</col>
- <col name="Alexa">1</col>
- <col name="Ask">0</col>
- <col name="Babylon">1</col>
- <col name="Bing">0</col>
<col name="Google">0</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">1</col>
+ <col name="Babylon">1</col>
</row>
<row>
<col name="label">search term 3</col>
- <col name="Alexa">0</col>
- <col name="Ask">1</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 4</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">1</col>
<col name="Google">0</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">that search term</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 1</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">1</col>
<col name="Google">0</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
index 4c9fe03b6f..1adf9d722a 100644
--- a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -2,56 +2,56 @@
<result>
<row>
<col name="label">this search term</col>
- <col name="Alexa">0</col>
- <col name="Ask">1</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 2</col>
- <col name="Alexa">1</col>
- <col name="Ask">0</col>
- <col name="Babylon">1</col>
- <col name="Bing">0</col>
<col name="Google">0</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">1</col>
+ <col name="Babylon">1</col>
</row>
<row>
<col name="label">search term 3</col>
- <col name="Alexa">0</col>
- <col name="Ask">1</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 4</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">1</col>
<col name="Google">0</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">that search term</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">0</col>
<col name="Google">1</col>
<col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
<row>
<col name="label">search term 1</col>
- <col name="Alexa">0</col>
- <col name="Ask">0</col>
- <col name="Babylon">0</col>
- <col name="Bing">1</col>
<col name="Google">0</col>
<col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
</row>
</result> \ No newline at end of file