Best Of
Re: DOMO Excel Plug-in Filters
I think we'd need a bit more information to help with the question. I use workbench from importing Excel files. You can select the worksheet and add transformations to perform the type of filtering mentioned.
Re: MySQL Workflow
@ArborRose Yes, the 500k limit is just referring to previewing the data. According to this best practices article, MySQL dataflows are best suited for transformations where the inputs are under 100 million rows. It's not out of ordinary to have MySQL run times beyond 30 minutes, but you should be able to optimize the dataflow by using indexes, reducing the number of joins, and only selecting the necessary rows and columns in each transform step.
Re: Ranking card
@zuchu You would use RANK() or DENSE_RANK() in a beastmode on your card. It would be something like this:
RANK()OVER(ORDER BY SUM('Sales') DESC)
Then put your companies as a column and your beast mode as a column. Here's and article about the difference between RANK() and DENSE_RANK():
If you end up with ties and you don't want any, you can a second aggregation after SUM('Sales') that would be used as a tie breaker.
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
I will share this, it is always helpful to have the community submit the feedback as well directly (under "More ->FEEDBACK). This feedback is reviewed by the Domo team.
McSQL
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
This has come up in our workflow again and would drastically improve Domo for our end users. Please, work on this as soon as you can.
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
we're currently in a situation where this would greatly improve our governance. please make this a thing, Domo!
Re: Count Unique IDs by Month-Year
Hi @tmerchant in that case you would want to remove Unique ID from your Group By fields. Then you can join back to previous tile on the year/month field.