Comments
-
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…
