Kibana: TSVB Sorting by column not working in dashboards

[IgnisIngenii]

Kibana version: 7.4.1

Elasticsearch version: 7.4.1

Server OS version: 7.6

Browser version: Chrome

Browser OS version: MacOS Mojave 10.14.5

Original install method (e.g. download page, yum, from source, etc.): download page

Describe the bug: When sorting a TSVB Table within a dashboard by one of its sortable columns, the visualisation returns a message stating 'No data to display for the selected metrics'. You'll now need to refresh the page in order to 'get your data back'. The sorting however works fine within the visualisation's editing-page.

Steps to reproduce:

1. Create a TSVB Table and save it to a dashboard. In this case, the two aggregations used are a sum and a filter ratio. The filter ratio returns a percentage, which is not sortable.
2. Try sorting one of the columns that is/should be sortable.
3. The visualisation returns the 'No data to display for the selected metrics'-message.

Expected behavior: The sort-functionality should work within a dashboard, as it works fine within the editing-page.

Screenshots (if relevant):

1. The table within a dashboard. The highlighted column should be sortable.

2. Once the sorting action is performed, this message is returned.

3. Within the editing-page, the sorting works just fine.

Cheers.

[csurett]

I have the same issue. When sorting a TSVB by column in a dashboard it says No data to display for the selected metrics

Cluster Info

Installed through: Yum
Kibana: 7.5.1
Elasticsearch: 7.5.1
Server os: RHEL 7 and OEL 7

Browser info

Browsers: Chrome 79.0.3945.117 and Microsoft Edge 42.17134.1098.0
OS: Windows 10 Enterprise

Possible issue

The request to api/metrics/vis/data has only a single change of state in the payload from {} to null

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[RagulPandiyan]

Facing same issue. Any update in this?

[qualispec]

I am also experiencing the same issue on Elasticsearch / Kibana version 7.5.0, browser version Chrome Version 80.0.3987.149.

[qualispec]

Is it possible to have this issue prioritized?

This issue, coupled with TSVB Table sorting being broken (https://github.com/elastic/kibana/issues/51888), is putting the TSVB Table visualization in an unusable state.