[BUG] Sorting is not working as expected in TSVB visualization

[CCongWang]

Describe the bug

Sorting is not working correctly in TSVB visualization after changing global filter

To Reproduce Steps to reproduce the behavior:

1. Add eCommerce sample data

2. Create TSVB visualization with the following config, I need to choose ignore global filter as yes

3. Add the TSVB visualization to eCommerce dashboards, change the sorting to sort by count ascendingly

4. Use the [eCommerce] Controls to add a category as filter, now the sorting arrow goes to Category Type, but the table is still sorted by count

Expected behavior

The sorting in TSVB visualization should keep the same, and the sorting arrow should reflect the sorting

OpenSearch Version 1.3.2

Dashboards Version 1.3.2

Plugins

Query Workbench, Reporting, Alerting, Anomaly Detection, Observability, Index Management, Security

Screenshots

see reproducing steps

Host/Environment (please complete the following information):

• OS: macos
• Browser and version: firefox: 102.2.0esr (64-bit)

Additional context

Add any other context about the problem here.

[CCongWang]

Hi team, any updates?

[ananzh]

Let me reproduce it. Thanks @CCongWang for opening this issue.

[ananzh]

I could not reproduce it. I used both 1.3.2 and current main. I could sort by category and count. Below images are from 1.3.2

[AMoo-Miki]

What i observed is that the sorting remains as it was chosen (which is good) but the arrow jumped over which is the problem.

[ananzh]

We reproduced the issue. Ideal fix should be to allow customer keep the sort state before refresh.

[CCongWang]

Hi team, any updates?

[ahopp]

@AMoo-Miki @ananzh Can we check is this is still an issue in the current version? I've seeing the correct behavior in the playground but I might be missing something.

If it is still an issue, @dagneyb is this something we can prioritize?

[ananzh]

@ahopp @dagneyb Yes it is still an issue.

[alan89202]

hello, any update on this issue?