Best Of
Re: Dataset refresh failure notifications
We had a similar use case and created a group email address, set up a user in Domo with that email, and then made that user the owner of the process the group needed a notification about.
akeating
Re: Dataset refresh failure notifications
Currently it's not an option until they allow group ownership of datasets. You could utilize an email address that would then forward emails to a group but that would have to be handled in your email server outside of Domo.
Re: Dynamic Rank Beast Mode
Are you using RANK in a window function? It sounds like you don't want any missing numbers in your sequence. Rank will ignore numbers if there are ties in your dataset. In this case you might want to try DENSE_RANK instead as that won't have any skipped rank numbers.
Re: Return most recent row/date
@AdamC You can use a Rank & Window tile:
https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window
Using Row Number as the function, then ordering by EVENTTIME descending, and partitioning by EQUIPMENT_NUMBER. This new column that's created will assign the most recent date for each equipment number a value of 1 and you can just filter to only allow where the row number is 1.
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
