Best Of

Domo isn't loading my excel files

Hi everyone, can anyone give any tips for loading an excel file with approximately 250,000 rows of data (some files about 60K KB, i've uploaded larger file sizes before)? It's to a dataset that is set to append but every time I upload it and click "save", and it imports, I go to check via Explorer view and I dont see the data. Does anyone have any tricks? I've already spliced the original file from about 750K rows into what I thought were three manageable excel files?

Thanks in advance !

Aeyai

AeyaiSaengkeo

1

How do I remove the "Warning: Not All the Data is Shown" from a filter?

I'm adding a filter to categorize our sales into 3 groups. I get this message no matter what settings/chart types I try. Screenshots show all-time for the date field, but when I tried to do the bare minimum needed for the page it's on (one year) I still get the message.

How do I remove this? Any workarounds or alternatives?

Thanks as always for any help.

moneyshot

1

Re: Warning: Not all the data is shown

Yes, that's what I kept thinking too, paginating would be nice, not sure it's possible.

user012334

1

Re: Warning: Not all the data is shown

@Jeffsnake In a perfect world and you could see all rows in the table what is the expectation of what the end user would do for a table card (asking so I understand how they might use it), want to make sure I'm understanding the pain point correctly. Not having editing capabilities limits what they can do in Domo so if all Ex. 200,000 rows were available in the browser in a table what happens next that isn't available to them now? I'd love to see more capabilities in Domo of what a non edit user can do with a table card in terms of creating some pivots/groupings on the go and things like that. What's an example of how it's done in another BI tool?

guitarhero23

1

Re: Warning: Not all the data is shown

That seems a little dramatic, Domo it plenty useful for hundreds of other things, just because a limitation exists on the amount of rows shown on a table card doesn't make the whole platform worthless. I don't know whether it's a technical limitation they set because of how Domo handles that data being shown or they limit it due to browser performance degredation or something else but I usually take it as a hint that looking at thousands of rows of data isn't really the best thing for the end user to do. Are you expecting them to actually look through 10,000 rows of data? The whole point of Domo and other BI platforms is to take all of this data and present it in a meaningful, higher level way and then with the power of drilling down dive deeper into specific sections. So you build the cards so that when they get down to the table it is a smaller subset of data that hopefully is less than 1,000 rows. If it's more yes, you should export it out and perhaps use something like Excel to do further manipulation of viewing. What is your use case that you need a user to read all over 1,000 individual rows? Why don't they add a filter to reduce the amount of rows? It may be nice if the limit was raised to something over 1,000 but what's a realistic number you'd want? Why would you ever want a user to browse 100,000 rows in a table in a browser?

guitarhero23

3