DomoDork Contributor

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…