Currently, when we download csv from a dashboard's saved search it exports additional columns along with the columns we selected as part of saved search. These additional columns are nothing but json data which is not human readable.
Additionally, it messes up entire downloaded csv when we try to open it in MS excel. This is because the json column may have data more than 32767 characters and excel does not support this much data into one single cell resulting into occupying next available row, which in turn messes up entire spreadsheet.
Expose formatted (download) option in saved search just like how its available in 'visualization'
Limit number of columns to be exported to only those columns which are selected in saved search.
Replication of issue:
1. Create a saved search in Discover (Can use dataprofile index, with just entity typeID as column)
2. Load it in dashboard
3. Download csv
4. Open it in MS Excel. (Don't use google spreadsheet, as data gets truncated if column size is > 32767)
|Customer Impact||Major inconvenience|