Skip to Main Content
Zaloni Ideas
Status On the Backlog
Categories Dashboards
Created by Ajinkya Rasam
Created on Oct 16, 2019

Ability to download user friendly data from dashboard

Hi,

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)

Support Ticket PS-18885
Customer Impact Major inconvenience
  • Attach files
  • Admin
    Matthew Monahan
    Oct 21, 2019

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