Name of affected component: Core Reporting API
Issue summary:
When querying for metric ga:users, dimension ga:daysSinceLastSession; ordering
by ga:daysSinceLastSession returns values ordered as string (1, 10, 100, 101,
11, 2, etc.) instead of being compared as number (1, 2, 3, etc.)
Steps to reproduce issue:
1. Make a query to Core Reporting API, using ga:users as metric and
ga:daysSinceLastSession as dimension
2. Order results by "ga:daysSinceLastSession" or "-ga:daysSinceLastSession"
Expected output:
╒═════════════════════════��
�╤═══════════════╕
│ ga:daysSinceLastSession │ ga:users │
╞═════════════════════════��
�╪═══════════════╡
│ 0 │ X │
├─────────────────────────��
�┼───────────────┤
│ 1 │ X │
├─────────────────────────��
�┼───────────────┤
│ 2 │ X │
├─────────────────────────��
�┼───────────────┤
│ 3 │ X │
├─────────────────────────��
�┼───────────────┤
│ 4 │ X │
├─────────────────────────��
�┼───────────────┤
etc.
Actual results:
╒═════════════════════════��
�╤═══════════════╕
│ ga:daysSinceLastSession │ ga:users │
╞═════════════════════════��
�╪═══════════════╡
│ 0 │ X │
├─────────────────────────��
�┼───────────────┤
│ 1 │ X │
├─────────────────────────��
�┼───────────────┤
│ 10 │ X │
├─────────────────────────��
�┼───────────────┤
│ 100 │ X │
├─────────────────────────��
�┼───────────────┤
│ 102 │ X │
├─────────────────────────��
�┼───────────────┤
│ 11 │ X │
├─────────────────────────��
�┼───────────────┤
│ 110 │ X │
├─────────────────────────��
�┼───────────────┤
│ 2 │ X │
├─────────────────────────��
�┼───────────────┤
│ 20 │ X │
├─────────────────────────��
�┼───────────────┤
│ 21 │ X │
├─────────────────────────��
�┼───────────────┤
etc.
Notes:
This also happens without the order variable set, as probably the API is
ordering by default using "ga:daysSinceLastSession"
Original issue reported on code.google.com by potter...@gmail.com on 8 Jan 2015 at 1:37
Original issue reported on code.google.com by
potter...@gmail.com
on 8 Jan 2015 at 1:37