Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a block chart and I currently have an expression to count statuses. I'd like to group some of these statuses into a 'new' category. Instead of doing this in the script, can I define it in Expressions?
For example I'd like to say
if([Dashboard Status]='In Progress' OR [Dashboard Status]='Design', 'In Queue', 'xxx')
Thank you.
it would be better if you do as a calculated dimension instead, of using the expression, but yes it can be done
Hi Jen,
You can definitely Achieve the new category.
Use Pick() and Match functions.
See below.
PICK(MATCH([Dashboard Status],'In Progress' ,'Design'), 'In Queue', 'xxx')
let me know if you have any questions.
krishna
Got it! Thank you!