On various occasions I find myself writing formulas like (simplified version): eval cat=case(like(CC, "TenantA%"), "ABC", like(CC, "TenantB%"), "BBC", true(), "Enterprise") Or mapping the hosts to regions eval site=case(like(host, "%-au%"), "AWS US", like(host, "%-ac%"), "AWS CA", like(host, "%-ae%"), "AWS EU", true(), "UnKnown") Sometime I use the same mappings across many reports dashboards. Copy/paste does not cut it. Also sometimes they need to get updated. Any suggestion?
... View more