Table Type does not change from JSON to Table

I have made a Table with elasticsearch as a datasource.

The data is being shown as JSON.

When I change Table Transform to Table, or anything else, and refresh it, It has no effect on the visualization.

I want payment_status, site_name and sum as different columns in table.

What should be changed ?

if the query returns json that is the only option you have. Your query needs to return table formatted data. What data source do you use? Looks like elasticsearch. Try latest beta v4.5 we have updated the Elasticsearch datasource so that queries without a date histogram return table formatted data instead of json object

1 Like

Yes I am using Elasticsearch.

But looks like grafana 4.5 is not available for download .

http://docs.grafana.org/guides/whats-new-in-v4-5/