1 Reply Latest reply: Jan 11, 2018 6:39 PM by Luis Madriz RSS

    How to export all columns of data into Excel

    Joe Muente

      I've got a pretty basic dashboard I'm working on, with a couple charts and a table as visualizations.  My whole dataset is over 20 columns wide, but each visualization uses just a few of them.  On the sheet I can right click on any visualization and chose export data and easily get it to an Excel sheet, but the export will just include the columns relevant to the visualization I started with.  Is there a way to export ALL columns into a spreadsheet, not just the handful that are displayed in the visualization?

        • Re: How to export all columns of data into Excel
          Luis Madriz

          Hi Joe,

           

          I haven't been able to do it, so my workaround is creating a straight table as the last sheet for downloading purposes, I put the other little KPIs such as number of records, etc. As Excel struggles with more that 1M records I advise users if the number of records exceeds that amount...

           

          I hope this helps,

           

          Cheers,

           

          Luis