#15245: Enhancing Sorting to Support Table Cacluations

SachinPrakash reported 2017-05-18T20:24:01Z · last modified 2018-10-05T09:30:35Z

Enhancing Sorting to Support Table Cacluations

Dev	Pankaj.Isarka
QA	juhisindhani

Priority	Major
Complexity	Unknown

Component	Visual Analytics
Version	19.5

Currently, VA does not support sorting on a table calculation field. Enhance VA to support this requirement.

9 attachments

sort-by-column.png

2018-05-09T22:30:27Z

145 KB
sort-by-row.png

2018-05-09T22:30:27Z

142 KB
Scenario1.png

2018-09-04T10:07:40Z

118 KB
Scenario4.png

2018-09-04T10:07:41Z

114 KB
Scenario5.png

2018-09-04T10:07:41Z

118 KB
Scenario2.png

2018-09-04T10:07:41Z

116 KB
Scenario3.png

2018-09-04T10:07:41Z

116 KB
sorting.vizx

2018-09-06T23:19:09Z

295 KB
sorting2.vizx

2018-09-25T22:13:35Z

295 KB

All Comments (22) Change History

nhilam 2018-05-10T17:24:23Z · (edited)

There are certain table calculations whose values are dependent on the order, and changing the order will change the values as well. For example:

Column headings: A, B, C, D, E
Original values: 5, 7, 2, 0, 1
Table calc values (difference from previous): null, 2, -5, -2, 1

So what does it mean to sort the table calc values? One possible interpretation is to sort (null, 2, -5, -2, 1), resulting in (null, -5, -2, 1, 2), which causes the column headers to sort as (A, C, D, E, B). Thus we will end up with the following:

Column headings: A, C, D, E, B
Original values: 5, 2, 0, 1, 7
Table calc values (difference from previous): null, -3, -2, 1, 6

Note that the Table calc values themselves are changed due to the way they are computed. Thus this particular sorting scenario does NOT seem to make sense; one does not expect a sort operation to modify the values that are being sorted.

However, if there are multiple rows, then sorting in the vertical direction is still valid.

Thus we should allow sorting by table calculation values only when the sorting itself does NOT change the table calc values. For example, when the table calc is computed horizontally, then sorting vertically is allowed, and vice versa, and also allow sorting when the order of the original values does not affect the final values of the table calculations (i.e. % of total table calc).

In this ticket, we will add the following sorting scenarios involving table calculations:

Allow sorting in vertical and horizontal directions as applicable when the table calculation is one of the following:
- % Of Total
- Rank
- Percentile
For any other table calculations, allowing sorting only in the perpendicular direction:
- Allow sorting in the vertical direction as applicable when the "Summarize the values from" is not "Table (Down)" or is not based on the last dimension field in the Rows deck.
- Allow sorting in the horizontal direction as applicable when the "Summarize the values from" is not "Table (Across)" or is not based on the last dimension field in the Columns deck.

There are certain table calculations whose values are dependent on the order, and changing the order will change the values as well. For example:

Column headings: A, B, C, D, E
Original values: 5, 7, 2, 0, 1
Table calc values (difference from previous): null, 2, -5, -2, 1

Column headings: A, C, D, E, B
Original values: 5, 2, 0, 1, 7
Table calc values (difference from previous): null, -3, -2, 1, 6

However, if there are multiple rows, then sorting in the vertical direction is still valid.

In this ticket, we will add the following sorting scenarios involving table calculations:

Allow sorting in vertical and horizontal directions as applicable when the table calculation is one of the following:
- % Of Total
- Rank
- Percentile
For any other table calculations, allowing sorting only in the perpendicular direction:
- Allow sorting in the vertical direction as applicable when the "Summarize the values from" is not "Table (Down)" or is not based on the last dimension field in the Rows deck.
- Allow sorting in the horizontal direction as applicable when the "Summarize the values from" is not "Table (Across)" or is not based on the last dimension field in the Columns deck.

Pankaj.Isarka 2018-09-04T10:13:34Z · (edited)

Fixed following scenario:

Allow sorting in vertical and horizontal directions as applicable when the table calculation is one of the following:
- % Of Total
- Rank
- Percentile
For any other table calculations, allowing sorting only in the perpendicular direction:
- Allow sorting in the vertical direction as applicable when the "Summarize the values from" is not "Table (Down)" or is not based on the last dimension field in the Rows deck.
- Allow sorting in the horizontal direction as applicable when the "Summarize the values from" is not "Table (Across)" or is not based on the last dimension field in the Columns deck.

Please find attached screenshots

@Nhi just one question, Do we have to sort on Difference?

Thanks
Pankaj

Pankaj.Isarka 2018-09-04T10:18:52Z

Revision: 56042

Author: pisarka

Date: Tuesday, September 4, 2018 3:56:51 PM

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Cacluations

Changes:

-added sorting for table calculation templates

----

Pankaj.Isarka 2018-09-04T19:04:40Z · Edited by

nhilam

@nhi from your above comment

"Note that the Table calc values themselves are changed due to the way they are computed. Thus this particular sorting scenario does NOT seem to make sense; one does not expect a sort operation to modify the values that are being sorted."

So Do we need to add sorting for "difference" ?

Thanks

[Nhi] We just need to implement #1 and #2 at the bottom of this comment. Per #2 we allow sorting the "difference" only in the perpendicular direction. For example if table calc is "table across", then allow sorting in vertical direction, but not allow sorting in horizontal direction.

Pankaj.Isarka 2018-09-04T19:11:36Z · (edited)

Thanks Nhi for quick reply.
All required Changes checked as per your comment. at Revision: 56042, Please have a look and let me know if anything we missed.

Thanks
Pankaj

juhisindhani 2018-09-05T12:27:38Z

Hi,

We came across following issue for Enhancing Sorting to Support Table calculations :

When we add only one measure in either Row header or Column header, the sorting is disabled for any of the table calculation templates.

Please refer screenshot.

Pankaj.Isarka 2018-09-07T15:03:36Z · Edited by

nhilam

Hi Nhi
For this scenario there is explicit handling is done.

check below code.

if (_fieldsAPI.getDataFieldCount() == 1) {

return !TableCalcUtils.hasTableCalculation(getPivotModel().getPivotTableDataFields()[0]);

}

Commenting this code resolve this issue.
So shall i comment this code or this is done to meet any other requirement.

Thanks
Pankaj

[Nhi] I don't remember this code. However, just commenting it out will cause another scenario to fail. For example, if the code is commented out, this scenario will allow sorting in both vertical and horizontal direction, which is incorrect; please see #2 in this comment. Thus you'll need to either fix up the mentioned code, or add other logic if you comment it out. Just make sure both #1 and #2 are satisfied and that no other existing supported sort scenarios are broken.

Please also fix the following scenarios.

Scenario 1

Open the attached sorting.vizx workbook in VA, and goto Worksheet1
Note that it is currently sorted on the 2nd "% of Total SUM(Profit)..." row
Click the sort icon on the 1st row of "% of Total SUM(Profit)..."
Result: chart is sorted on 1st "% of Total SUM(Profit)..." row
Right click on the SUM(Profit) field in Rows deck and change its table calc to "Difference"
The sort icon on the 1st row disappears, which is correct
Click Undo twice -- the state is restored back to when the 2nd "% of Total SUM(Profit)..." row being sorted
Click Redo once -- the state is NOT restored back to when the 1st "% of Total SUM(Profit)..." row being sorted (state of step #4), which is incorrect

Scenario 2

Open the attached sorting.vizx workbook in VA, and goto Worksheet2
Click the sort icon on the 1st row of "Difference in SUM(Profit)..."
Result: chart is sorted on 1st "Difference in SUM(Profit)..." row
Right click on the SUM(Profit) field in Rows deck and change its "Calculate Difference Along" to "Table (Across)"
The sort icon on the 1st row disappears, which is correct
Click Undo
Result: The following error is displayed, which is incorrect: com.aquafold.components.pivottable.values.PivotTableSnapshotExpandableValue cannot be cast to com.aquafold.components.pivottable.values.PivotTableRunningSummaryValue
Expected: The Undo should restore the state back to same state as step #3.

Hi Nhi
For this scenario there is explicit handling is done.

check below code.

if (_fieldsAPI.getDataFieldCount() == 1) {

return !TableCalcUtils.hasTableCalculation(getPivotModel().getPivotTableDataFields()[0]);

}

Commenting this code resolve this issue.
So shall i comment this code or this is done to meet any other requirement.

Thanks
Pankaj

Please also fix the following scenarios.

Scenario 1

Open the attached sorting.vizx workbook in VA, and goto Worksheet1
Note that it is currently sorted on the 2nd "% of Total SUM(Profit)..." row
Click the sort icon on the 1st row of "% of Total SUM(Profit)..."
Result: chart is sorted on 1st "% of Total SUM(Profit)..." row
Right click on the SUM(Profit) field in Rows deck and change its table calc to "Difference"
The sort icon on the 1st row disappears, which is correct
Click Undo twice -- the state is restored back to when the 2nd "% of Total SUM(Profit)..." row being sorted
Click Redo once -- the state is NOT restored back to when the 1st "% of Total SUM(Profit)..." row being sorted (state of step #4), which is incorrect

Scenario 2

Open the attached sorting.vizx workbook in VA, and goto Worksheet2
Click the sort icon on the 1st row of "Difference in SUM(Profit)..."
Result: chart is sorted on 1st "Difference in SUM(Profit)..." row
Right click on the SUM(Profit) field in Rows deck and change its "Calculate Difference Along" to "Table (Across)"
The sort icon on the 1st row disappears, which is correct
Click Undo
Result: The following error is displayed, which is incorrect: com.aquafold.components.pivottable.values.PivotTableSnapshotExpandableValue cannot be cast to com.aquafold.components.pivottable.values.PivotTableRunningSummaryValue
Expected: The Undo should restore the state back to same state as step #3.

KomalAher 2018-09-11T13:55:38Z · (edited)

Fixed following scenarios:

a) When we add only one measure in either Row header or Column header, the sorting is disabled for any of the table calculation templates.
--FIXED

b) Scenario 1:

1. Open the attached sorting.vizx workbook in VA, and goto Worksheet1

2. Note that it is currently sorted on the 2nd "% of Total SUM(Profit)..." row

3. Click the sort icon on the 1st row of "% of Total SUM(Profit)..."

4. Result: chart is sorted on 1st "% of Total SUM(Profit)..." row

5. Right click on the SUM(Profit) field in Rows deck and change its table calc to "Difference"

6. The sort icon on the 1st row disappears, which is correct

7. Click Undo twice -- the state is restored back to when the 2nd "% of Total SUM(Profit)..." row being sorted

8. Click Redo once -- the state is NOT restored back to when the 1st "% of Total SUM(Profit)..." row being sorted (state of step #4), which is incorrect

--FIXED

c) Scenario 2:

1. Open the attached sorting.vizx workbook in VA, and goto Worksheet2

2. Click the sort icon on the 1st row of "Difference in SUM(Profit)..."

3. Result: chart is sorted on 1st "Difference in SUM(Profit)..." row

4. Right click on the SUM(Profit) field in Rows deck and change its "Calculate Difference Along" to "Table (Across)"

5. The sort icon on the 1st row disappears, which is correct

6. Click Undo

7. Result: The following error is displayed, which is incorrect: com.aquafold.components.pivottable.values.PivotTableSnapshotExpandableValue cannot be cast to com.aquafold.components.pivottable.values.PivotTableRunningSummaryValue

8. Expected: The Undo should restore the state back to same state as step #3.

--FIXED

KomalAher 2018-09-11T13:45:29Z

Amend :Revision # 56042 <visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

-Fixed reported issues.

nhilam 2018-09-12T18:10:32Z · (edited)

The following scenario is broken:

Scenario 3:

Open the attached sorting.vizx workbook in VA, and goto Worksheet2
Remove SUM(Freight) from Rows deck
Hover over the "ColonialVoice" column header
Result: A sort icon becomes available, which is incorrect.
Expected: Sorting vertically should NOT be allowed for table calc of "Difference From" using Table(Down)

Scenario 4:

Open the attached sorting.vizx workbook in VA, and goto Worksheet2
Remove SUM(Freight) from Rows deck
Right click on SUM(Freight) in the Rows deck, and change the "Calculate Difference Along" to "Table(Across)"
Hover over the "ColonialVoice" column header
Result: A sort icon is NOT available, which is incorrect.
Expected: Sorting vertically should be allowed for table calc of "Difference From" using Table(Across)

Scenario 5:

Open the attached sorting.vizx workbook in VA, and goto Worksheet1
Hover on the 1st row of SUM(Freight) in the row header area, and click on the sort icon
Result: The table is sorted on the 1st rows of "% of Total SUM(Profit)", which is incorrect
Expected: The table should be sorted on the 1st rows of SUM(Freight)

After you fix this, please verify that when table calc is Table(Across), then sorting vertically is allowed, but sorting horizontally is not allowed. And when table calc is Table(Down), then sorting vertically is not allowed, but sorting horizontally is allowed. You should also swap rows/columns, and validate the same. Also validate the same in Chart mode.

KomalAher 2018-09-20T12:51:54Z

Hi Nhi,

Above Scenarios no. 3, 4 and 5 are FIXED

Revision: 56146

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

-Fixed single measure field sorting issue

-Fixed the expected functionality of sorting

KomalAher 2018-09-24T15:29:09Z · Edited by

nhilam

Hi Nhi,

For Rank table calculation, the sorting is happening in opposite way. see below scenario:

Scenario 6:

1. Open the attached sorting.vizx workbook in VA

2. Right click on SUM(Profit) in the Rows deck, and change the "Table Calculation templates" to "Rank"

3. Click the sort icon on the 1st row of "Rank SUM(Profit)..."

3. Result: Sort icon is Descending whereas values are sorting in Ascending order and vise versa

4. Expected: if Sort icon is Descending, values should get sort in Descending order and vice versa.

Thanks, Komal

[Nhi] Please open up a new issue for this defect.

nhilam 2018-10-01T17:42:46Z · (edited)

Seems like the sorting scenarios are enabled and working in Table mode, but not enabled in Chart mode, which is incorrect. All scenarios in this issue must be enabled and work for both Table and Chart mode.

Scenario 1:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Hover over the "ColonialVoice" row header, and notice sort icon is available, which is correct.
Hover over the "Australia" column header, and notice sort icon is available, which is correct.
Right click on SUM(Freight) field and select Table Calc Templates > Percentage of Total
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Summarize Values From > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.

Scenario 2:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Right click on SUM(Freight) field and select Table Calc Templates > Difference
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Calculate Difference Along > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.

Scenario 3:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 4
Hover over the "ColonialVoice" row header, and notice sort icon is available, which is correct.
Hover over the "Australia" column header, and notice sort icon is available, which is correct.
Right click on SUM(Freight) field and select Table Calc Templates > Percentage of Total
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Summarize Values From > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.

Scenario 4:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 4
Right click on SUM(Freight) field and select Table Calc Templates > Difference
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Calculate Difference Along > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.

Scenario 1:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Hover over the "ColonialVoice" row header, and notice sort icon is available, which is correct.
Hover over the "Australia" column header, and notice sort icon is available, which is correct.
Right click on SUM(Freight) field and select Table Calc Templates > Percentage of Total
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Summarize Values From > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.

Scenario 2:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Right click on SUM(Freight) field and select Table Calc Templates > Difference
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Calculate Difference Along > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.

Scenario 3:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 4
Hover over the "ColonialVoice" row header, and notice sort icon is available, which is correct.
Hover over the "Australia" column header, and notice sort icon is available, which is correct.
Right click on SUM(Freight) field and select Table Calc Templates > Percentage of Total
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Summarize Values From > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.

Scenario 4:

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 4
Right click on SUM(Freight) field and select Table Calc Templates > Difference
Hover over the "Australia" column header
Result: No sort icon available, which is incorrect.
Right click on SUM(Freight) field and select Calculate Difference Along > Table (Down)
Hover over the "ColonialVoice" row header
Result: No sort icon available, which is incorrect.

KomalAher 2018-09-27T07:30:28Z

Hi Nhi,

above scenarios of chart mode are FIXED.

Revision: 56178

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

-Fixed sorting issues for chart mode

KomalAher 2018-09-27T14:01:48Z

above scenarios of chart mode are FIXED.

Revision: 56184

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

-Fixed sorting issues for chart mode

juhisindhani 2018-10-01T08:44:00Z

We have verified all the above scenarios and its working fine on Dev-46 build.

nhilam 2018-10-01T21:21:01Z · (edited)

It seems like the logic in the following block of code in BIModel, line 1487 is a bit strange:

if (hasTableCalculation) {
	_allowSortByLeafColumn = _allowSortByColumn && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
	_allowSortByLeafRow = _allowSortByRow && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);
}
else {
	_allowSortByLeafColumn = _allowSortByColumn && !hasTableCalculation && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
	_allowSortByLeafRow = _allowSortByRow && !hasTableCalculation && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);
}

It can be simplified as follows:

_allowSortByLeafColumn = _allowSortByColumn && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
_allowSortByLeafRow = _allowSortByRow && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);

Please fix and re-test.

It seems like the logic in the following block of code in BIModel, line 1487 is a bit strange:

if (hasTableCalculation) {
	_allowSortByLeafColumn = _allowSortByColumn && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
	_allowSortByLeafRow = _allowSortByRow && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);
}
else {
	_allowSortByLeafColumn = _allowSortByColumn && !hasTableCalculation && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
	_allowSortByLeafRow = _allowSortByRow && !hasTableCalculation && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);
}

It can be simplified as follows:

_allowSortByLeafColumn = _allowSortByColumn && (!_fieldsAPI.isDataInColumns() || _fieldsAPI.getDataFieldCount() < 2);
_allowSortByLeafRow = _allowSortByRow && (!_fieldsAPI.isDataInRows() || _fieldsAPI.getDataFieldCount() < 2);

Please fix and re-test.

KomalAher 2018-10-02T07:13:16Z

Thanks Nhi.

Fixed above code and its working fine.

Revision: 56205

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

- Code Refactoring

nhilam 2018-10-02T18:32:20Z

The code refactoring in BIChartHeaderHoverHandler is invalid as it cause breakage in the following scenario. Please revert the changes in BIChartHeaderHoverHandler that was part of Revision 56205.

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Remove the SUM(Freight) from the Rows deck
Hover over the "ColonialVoice" row header or "Australia" column header
Result: The following exception is generated in the log file:

java.lang.ArrayIndexOutOfBoundsException: 0
   at com.aquafold.aquacore.open.chart.bi.BIChartHeaderHoverHandler.isAllowSorting(BIChartHeaderHoverHandler.java:174)
   at com.aquafold.aquacore.open.chart.bi.BIChartHeaderHoverHandler.handleSelection(BIChartHeaderHoverHandler.java:114)
   at com.aquafold.aquacore.open.chart.bi.BIChartPanel$BIChartMouseAdapter.mouseMoved(BIChartPanel.java:1025)
   at java.awt.Component.processMouseMotionEvent(Component.java:6578)
   at javax.swing.JComponent.processMouseMotionEvent(JComponent.java:3342)
   at java.awt.Component.processEvent(Component.java:6302)
   at java.awt.Container.processEvent(Container.java:2238)
   at java.awt.Component.dispatchEventImpl(Component.java:4889)
   at java.awt.Container.dispatchEventImpl(Container.java:2296)
   at java.awt.Component.dispatchEvent(Component.java:4711)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4897)
   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4475)
   at java.awt.Container.dispatchEventImpl(Container.java:2282)
   at java.awt.Window.dispatchEventImpl(Window.java:2746)
   at java.awt.Component.dispatchEvent(Component.java:4711)
   at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
   at java.awt.EventQueue.access$500(EventQueue.java:97)
   at java.awt.EventQueue$3.run(EventQueue.java:709)
   at java.awt.EventQueue$3.run(EventQueue.java:703)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
   at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
   at java.awt.EventQueue$4.run(EventQueue.java:733)
   at java.awt.EventQueue$4.run(EventQueue.java:731)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
   at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:866)
   at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:650)
   at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:381)
   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

The code refactoring in BIChartHeaderHoverHandler is invalid as it cause breakage in the following scenario. Please revert the changes in BIChartHeaderHoverHandler that was part of Revision 56205.

Open the attached sorting2.vizx workbook in VA, and goto Worksheet 3
Remove the SUM(Freight) from the Rows deck
Hover over the "ColonialVoice" row header or "Australia" column header
Result: The following exception is generated in the log file:

KomalAher 2018-10-03T09:24:35Z

Revision: 56212

Message:

<visualanalytics:#15245> Enhancing Sorting to Support Table Calculations

Changes:

- Reverted the changes in BIChartHeaderHoverHandler

nhilam 2018-10-03T23:51:00Z

Looks good.

@QA: Please test and verify the issue.

juhisindhani 2018-10-05T09:30:35Z

Hi, we have verified all the above scenarios and its working fine on Dev-51 build.

Search Tips

Aqua Data Studio / nhilam

Enhancing Sorting to Support Table Cacluations

9 attachments

Issue #15245

Completion

2 issue links

Issue #15625

Issue #15551

Search Tips

Aqua Data Studio / nhilam

Title

Enhancing Sorting to Support Table Cacluations

9 attachments

Issue #15245

Completion

2 issue links

Issue #15625

Issue #15551