I have a requirement to show percentage value in a data table and send it as a report to user for the mentioned interval. In normal Data table visualization we have Formatted , CSV to export raw data from the kibana, but same thing is not there in Visual builder
I have a challenge here to use Data Table ,
I need to take sum of field1 and sum of field 2 then calculate the percentage of field1 and field2.
I am not able to achieve this in Data table visualization, but this can be done in TSVB using Bucket script , but there i don't have an option to export the data.
Can you please suggest me a better approach to my problem!!