Excel Plugin not pulling data consistently

I am running into an issue where identical data pulls are returning different results. Please help!
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
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.
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有