Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev | mattbrumley(*) |
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Open API - Chart |
| Version | 09.0 |
From Fung:
The pivot chart implemented by AQChart does not seem to correct if there are multiple pivot row/column fields involved. Not sure if this is a known issue or not, to reproduce:
(1) In ADS, select 'SQL Server 2000 - 54' server and open a Query Analyzer panel.
(2) Select Northwind database and execute 'select top 9 * from orders;'
(3) Go to 'Pivot Grid' tab and create the following fields:
2 row fields - ShipeCountry and ShipName
2 column fields - ShipeRegion and ShipCity
1 data field - Freight
(4) The pivot table resulted from above row/column/data fields definition contains 9 data cells
(excluding those displayed in row/column grand total cells)
(5) Now, click the chart icon to display pivot chart, only two cells have positive values, the rest of them are all zeros.
Similarly, the pivot chart saved to the Excel file is incorrect when multiple row/column fields involved.
I'm also attaching a pivot chart generated manually in Excel to depict how it should look like.
|
|
33 KB
|
60 KB
|
|
208 KB
|
|
169 KB
Additional points of note:
1) To create the above defect, ensure that ShipRegion is the first column field & ShipCity is the second column field.
-- If ShipCity is the first column field & ShipRegion is the second column field, then the chart seems to display the correct data
2) If I have ShipRegion as the first column & ShipCity as the second column & then re-execute my query, the pivot grid automatically switches ShipCity to the first Column field & ShipRegion as the second column field.
[x] 4474 Incorrect pivot graph when multiple pivot row/column fields involved
[x] 4474 Incorrect pivot graph when multiple pivot row/column fields involved
Resolved in latest build ADS 9 beta 1.00 and Build #: 15229 .. see before and after pics
Resolved in latest build ADS 9 beta 1.00 and Build #: 15229 .. see before and after pics
Matt,
The incorrect pivot graph has been resolved. But if we re-execute the query the changing positions of fields still occurs. See#2
2) If I have ShipRegion as the first column & ShipCity as the second column & then re-execute my query, the pivot grid automatically switches ShipCity to the first Column field & ShipRegion as the second column field.
Matt,
The incorrect pivot graph has been resolved. But if we re-execute the query the changing positions of fields still occurs. See#2
2) If I have ShipRegion as the first column & ShipCity as the second column & then re-execute my query, the pivot grid automatically switches ShipCity to the first Column field & ShipRegion as the second column field.
Issue #4474 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Additional points of note:
1) To create the above defect, ensure that ShipRegion is the first column field & ShipCity is the second column field.
-- If ShipCity is the first column field & ShipRegion is the second column field, then the chart seems to display the correct data
2) If I have ShipRegion as the first column & ShipCity as the second column & then re-execute my query, the pivot grid automatically switches ShipCity to the first Column field & ShipRegion as the second column field.