Arena Customer Ideas

Ability to download user friendly data from dashboard


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.

Potential solutions:

  1. Expose formatted (download) option in saved search just like how its available in 'visualization'

  2. 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)

  • Ajinkya Rasam
  • Oct 16 2019
  • Future consideration
Support Ticket PS-18885
Customer Impact Major inconvenience
  • Attach files
  • Admin
    Matthew Monahan commented
    21 Oct, 2019 01:16pm

    We will re-evaluate this request at a future date.