#15625: For Rank table calculation, the sorting is happening in opposite way

juhisindhani reported 2018-09-25T14:46:42Z · last modified 2018-10-19T07:12:49Z

For Rank table calculation, the sorting is happening in opposite way

Dev	nhilam
QA

Priority	Major
Complexity	Unknown

Component	Visual Analytics
Version	19.5

Steps to reproduce the issue:

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.

2 attachments

sorting.vizx

2018-09-25T14:46:42Z

295 KB
patchFile

2018-10-05T10:45:35Z

885 B

All Comments (6) Change History

Pankaj.Isarka 2018-09-25T14:52:18Z · (edited)

Hi Nhi
I have investigated this issue,
Changing SORT_ORDER_ASCENDING ll resolve this issue(If this is an issue)

Class: CommonTableCalculation

case PivotTableConstants.RUNNING_SUMMARY_RANK:
   runningSummary.setRankingTiesStrategy(TiesStrategy.MINIMUM);
   runningSummary.setRankingPercentileSortOrder(PivotField.SORT_ORDER_DESCENDING);
   break;

Hi Nhi
I have investigated this issue,
Changing SORT_ORDER_ASCENDING ll resolve this issue(If this is an issue)

Class: CommonTableCalculation

case PivotTableConstants.RUNNING_SUMMARY_RANK:
   runningSummary.setRankingTiesStrategy(TiesStrategy.MINIMUM);
   runningSummary.setRankingPercentileSortOrder(PivotField.SORT_ORDER_DESCENDING);
   break;

nhilam 2018-10-01T17:29:24Z · (edited)

Please attach a patch file for your proposed changes.

Pankaj.Isarka 2018-10-05T10:46:49Z

@Nhi added the patch file

nhilam 2018-10-17T00:39:01Z

Please go ahead and check in the patch

Pankaj.Isarka 2018-10-17T05:58:58Z

checked in available on the build 64.
Revision: 56282

Author: pisarka

Date: Wednesday, October 17, 2018 11:37:45 AM

Message:

<datastudio #15625>For Rank table calculation, the sorting is happening in the opposite way

----

juhisindhani 2018-10-19T07:12:49Z

Hi,

For Rank table calculations the sorting is happening as per the expectations on ADS19.5.0-dev-65 build. Hence marking it as Verified.

Thanks,

Priyanka

Search Tips

Aqua Data Studio / nhilam

For Rank table calculation, the sorting is happening in opposite way

2 attachments

Issue #15625

Completion

1 issue link

Issue #15245

Search Tips

Aqua Data Studio / nhilam

Title

For Rank table calculation, the sorting is happening in opposite way

2 attachments

Issue #15625

Completion

1 issue link

Issue #15245