[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.