To export data from the Insights:
...
Often times you want to take the insights data and use it for further analysis using MS Excel or other analytics tools.
The Discover page in Insights does not have an option to download the data. However, you can create a Data Table visualization for the same search query and download the data in the .csv format.
Discover
For example, you want to check the Answers feedback data that is captured in insights.
You will go to Insights > Discover and then choose the data-<environment>-backend.answers_feedback index pattern.
Choose the columns that you want to view in the table form.
You can do it in one of the two ways.Click on the add button against the field from the Available fields section.
Expand a document and select the Table tab. Click on the Toggle column in table icon. It will be added to the table.
You can see the data in a table form.
Note the selected fields section contains the column names.
Visualize
Follow the below steps to visualize the same data and get export it.
Go to Visualization.
Create /Selecta visualization. Refer, https://orbita.atlassian.net/wiki/spaces/OCS/pages/7111174/Guide+to+Orbita+Insights#Visualize
Choose the visualization type as Data Table.
Select the saved search.
You will land on the visualization page with the total count.
Create buckets to split the data.
Click on Add and then click on Split rows
Select terms from the Aggregation drop down.
Select a field from the Field dropdown
Change the size (typically to populate the total number of rows of the table)
Enable Show missing values.
Click the Play icon at the top after configuring the required buckets to apply the changes.
Click on the Raw button or Formatted button to download the data table you just created in .csv format.
The data will be downloaded as a CSV file.
...