DomoDork Contributor

Hi @pimogo I realize this is an old post at this point and you've probably already solved it, but here is how I did it in a DOMO brick. <a href="#" onclick="javascript:domo.navigate('/page/-100000/kpis/details/1259181756', true);"> The true parameter will open the link in a new tab/window, false will open the link in the…

Isn't using MySQL about 3x the cost from a pricing perspective compared to a MagicETL execution? Thats not something everyone wants to swallow. But @Simon_King - I just remembered that in the last Domopolooza event, they showed off a SQL Tile in MagicETL that is coming very very soon so theoretically that would work!

I wholeheartedly agree with the idea of a seperate sort tile. Rank and Window is fine, but not every situation calls for a window function or the additional configuration/grouping options needed for Rank and Window to function the way you want or expect. And as Apurkhardt mentions, there are actual use cases that rank and…

I'm working through PDP automation as a new customer and this is exactly what I struggle with. Since I can't impersonate other users as Admin, it's extremely difficult to verify and audit that PDP is working as expected. This would be HUGE and very much needed.

Agreed. I'm a new customer with Domo so I'm in the middle of a planning phase to get the platform setup the way we need it before rolling it out to the wider company but one of the features we were looking at was the fiscal calendar. I'm in the same boat as you where I've got a ton of clients and all of them their own take…

Thanks Grant! That seems like an oversight that can be easily implemented. I'll submit feedback to my CSM and the idea exchange.

@pstrauss You're very welcome! If you try it out and get stuck or need any guidance please feel free to message me directly and I'll help where I can. If you implement it successfully, a quick follow-up here would be greatly appreciated as well. I'm just trying to be mindful of others who might find this technique useful…

Hi pstrauss, You can do this in a MagicETL. The best way I've found to do this is using the Python Scripting Block. In the example I put together for you, I wanted to make it simple to configure which words end up capitalized without having to reconfigure my ETL every time I want to add a new preposition. In the design…

Hey kpmwinston - I recently had this same requirement and solved it via MagicETL and using the Dynamic Unpivot + Python Scriprting blocks. The idea goes something like this: Add dataset A as a datasouce in MagicETL Add dataset B as a 2nd datasource in MagicETL Drag two unpivot blocks into your flow, and connect one to…