How to View/Download large tables

user003049
user003049 Member
in Charting

Help, I need to know how to view and download large tables in Domo.

 

I've been using the Sumo table but the downside is I can't download the pivoted data as shown in Domo.

The new mega tables and pivot tables work, but there seems to be a data cap and only part of the data is shown, which is very confusing.

A team member found out that if you open a table with Analyser and hit save, all the data is displayed again.

But we cannot do this with every table all the time.

 

Is there a way to display and download large tables in Domo?
Also for future reference, what is the upper data limit for each table?

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    What do you mean by 'large tables'

     

    Keep in mind, the core design of Domo is to support driving actionable data, I appreciate it may be frustrating to not be able to see 10,000 rows of data, if that's what you're accustomed to in Excel... but that's not really the design principles behind Domo.

     

    What you could do is build a pivot table / mega table in a Dashboard and then add filter cards around it.  Then use that to isolate the data you want and export data from the table card.

     

    Alternatively you can use the Domo Excel Addon (Admin > Tools > Downloads) to import data into Excel, keep in mind if you're talking about moving millions of rows, you'll probably crash the connection and / or excel b/c it really wasn't designed to be a table export tool.

     

    If you want to access the data in a SQL environment there is a premium feature an ODBC connector.  Ask your account executive for details.

     

    You can also use the Java CLI (also under Admin > Tools > Downloads) to export slices of data  using the query-data command.

     

    LASTLY AND MOST USEFUL ANSWER (IMHO)

    Domo has a data views beta that was previewed at Domopalooza and demoed during the Domo EMEA User Group 3 weeks ago, that allows you to use a UI to generate views of data (like you're currently creating views in cards).  These views will persist and allow you to create manageable cuts of data that you can export as CSV etc.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user090374
    user090374 Domo Employee

    Hi @user003049 ,

     

    @jaeW_at_Onyx 's solution for adding filter cards and isolating data that way to export would likely be your best bet. Some notes: 

    • When you export a KPI Card to a Microsoft PowerPoint presentation, it appears as is, in its Card state. When you export a Card to Excel or CSV, only the data from the Card is pulled; graphical elements of the Card do not appear. 

    • When exporting a table Card with aggregations grouping rows together, the data will remain aggregated. To see the raw data, you must remove the aggregation in your table first, then export.

    • Be aware that when you export Heat Map Tables to Excel or CSV, the exported data may appear differently than expected, as it renders to match the table view of the data, not the Card view. For more information about Heat Map Tables, see Table. For more information about the table view, see Card Details View Layout - Table view.

    • You can use a spreadsheet or text editor application to open a .csv file to see the exported data.

    • When any user exports a Card, an event called "Exported DataSet" appears in the Activity Log in Admin Settings. This may lead to the assumption that the user who exported the Card has access to the DataSet, but this is not necessarily the case.  

    • If your data contains a string data type column that contains only numeric values, such as zipcodes, it will be exported with a single quote added to the beginning of every value in the column to prevent Excel from enabling their auto macro functionality. (e.g. '84084) 

    • Both CSV and XLSX exports append a single quote on string columns displaying negative numbers. This is for security purposes, to prevent auto-macro functionality. If you remove the quotes, the cell values immediately become active macros. 

    By default, Domo disables any formulas in Excel files before they are exported (as these formulas could contain malicious code). If you are an Admin user or have a custom role with the "Manage All Company Settings" privilege enabled, you can re-enable Excel formulas when exporting by doing into Admin Settings > Security > Exporting data and unchecking the box reading "Disable Excel formulas." However, it is strongly recommended that you do not uncheck this box.  

     

    You can export data from a Sumo card to a Microsoft Excel spreadsheet file or .csv file. You can export data from a Sumo card in either the page view or the Details view and will include sorts, filters, and aggregations. It does not include any "Total" rows. Exporting data from Pivot View to Microsoft Excel does not generate a Pivot table but exports the rows of data, which could be used in generating a Pivot table.

    If data in a card is filtered due to PDP policies, those filters are applied in the exported version. For more information about PDP, see Personalized Data Permissions (PDP).

    For more information about applying sorts, filters, and aggregations to a Sumo card, see Applying sorts, filters, and aggregations.

     

    I hope this helps!

This discussion has been closed.

Categories