AndreaHenderson Domo Product Manager

A few questions: Is the Python script updating the output dataset post-Magic ETL in order to update the column to 1? Is the output then brought back into the dataflow as an input? (thus creating a recursive dataflow) How are new rows added? (Via the original raw input dataset, perhaps?) Are the new rows ever updates to…

Thanks for the reply. I understand your usecase, and the feature you're looking for is a great idea. As you've noticed, we currently do not have such an offering. Please visit the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if…

Hello and thanks for your question! It's an interesting one with a lot of different potential resolutions, depending on your usecase. From what you said, it sounds like you utilize Domo to work with many different business clients, and that some of the business clients have conflicting fiscal calendars. A couple of…

Hello! Thanks for providing a screenshot with your question. Based on the error message, it looks like there is no data available in the dataset for the filters that are applied to the card. Unfortunately, without access to the underlying data and the card features, I don't have the ability to troubleshoot the issue.…

Sorry about that, I didn't have a way to test because I'm not in your instance of Domo. There is an erroneous comma after the first instance of 'UHC'. If you remove that, I think it will work.

Excellent, thanks for the clarification. I think my first pass at the Beast Mode should work for you, then. Click the "Add Calculated Field" button in the Analyzer interface, plug in the CASE statement, give the calculation a name and save. Let me know if you have further questions. Here is more info about Beast Mode…

For reference, here is my first pass at the Beast Mode: (CASE WHEN `Ins Product` = 'MCR Replcmt' THEN 'MCR Replcmt' WHEN `Financial Class` IN ('Medicare', 'Medicaid', 'Medicaid Replacement') THEN 'Medicare' WHEN `Plan Grp` = 'AETN' THEN 'AETNA' WHEN `Plan Grp` = 'BCTX' THEN 'BCBS' WHEN `Plan Grp` = 'CIGNA' THEN 'CIGNA'…

Hi! This sounds like a great case for a Beast Mode, and I'd be happy to write that for you. Can you please reply with your business logic in conversational English? I think I have it figured out from the Excel formula, but I want to be sure I have the correct logic before I write the Beast Mode. Thanks!

Interesting usecase! Our cards don't natively support ranking in that way, but you can use the Magic ETL tool to add a ranking column based on that country partition you mention. Here is a link to our Knowledge Base article that walks you through the process of using Magic to create this column. You will specifically want…