Excel Plugin not pulling data consistently

I am running into an issue where identical data pulls are returning different results. Please help!
Comments
-
Hi Scott, do you have the same number of rows/columns in your excel download? Has the underlying dataset in Domo changed since you downloaded each dataset? Is the pivot table picking up all the rows?
I ran into some issues where my dataset in Domo shrunk, but the excel plugin does not delete the old rows (had 100 rows, now have 80, Domo leaves the extra 20 in excel when it refreshes the data).
0 -
That's a good point. The two query tables were pulled in within 5 minutes of each other, and are looking at sales data from last year, so the data did not change. Each table has the same number of rows. Both pivot tables are using the entire data set to summarize the sales data.
0 -
Hi Scott, can you use a sumif/sumifs or vlookup in excel to narrow down the variances to specific rows? Are there any field values that contain what could be considered an operating character like a \ or " in the value (particularly at the end of a string). I have run into issues with those as well with the excel plugin.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive