[TSVB] [Rollup] Table tab not working with rollup indexes

[alexwizp]

Kibana version: v.7.9?, v7.10, master

Describe the bug:
[TSVB] [Rollup] Table tab not working with rollup indexes

Steps to reproduce:

1. Create the Rollup Index and go to TSVB visualization
2. Configure TSVB to use that index and go to Table tab

Actual result:
Error:

The request for this panel failed
There is not a rollup job that has a [terms] agg on field [products.base_unit_price] which also satisfies all requirements of query.

Expected behavior:
User should be able to see table data based on Rollup index.

Screenshots (if relevant):

[elasticmachine]

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

[flash1293]

@alexwizp Just to make sure - Rollup indices only support this operation if products.unit_price was selected in the "terms" section of the rollup index setup wizard. Otherwise this is expected behavior. Did you configure your rollup job this way?

[alexwizp]

@flash1293 sure, in TSVB we show users only filtered fields which can be uses for specific rollup index. at least it was like that before =)

Anyway if I remove Group By value I see different type of error

[flash1293]

Maybe there are multiple problems at work here. I just tried this on current master and "group by" in the table works fine as long as rollup was configured correctly for a field. But the field dropdown is showing fields which are not configured for terms as well:

extension.keyword works fine, but bytes is only configured for average values, so it breaks when using it for terms. It looks like the field list is only filtered by whether a field has some rollup config attached and doesn't check the supported aggs.

I can verify the issue @alexwizp mentions above on removing the "group by".

[alexwizp]

@flash1293 thank you, it looks like here we just need to add filtering by fields that support terms aggregation.

we have everything we need to implement it in the data response: