on 04-12-2019 9:36 AM
I am looking to replace text in one object where a condition is met in another object. The example being that I have unknown being presented as an outcome in one object but it is related to two different outcomes in another object. I want to distinguish between the both if possible. What I have came up with so far is just bringing back blank outcomes
=Replace([Case Created By];"unknown";"WSSPortal") Where ([Case Category] = "Visit Request")
Any help would be much appreciated
Hi Chris,
Create the below variable and let us know if it serves your request.
New Cast Created By
=If([Case Category]="Visit Request") Then Replace([Case Created By];"unknown";"WSSPortal")
Else [Case Created By]
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If I understood you correctly, just define the new variable "Case_Created_By" and use it instead of the original dimension.
Case_Created_By: =if ([Case Category] = "Visit Request") then "WSSPortal" else "unknown"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.