Heyo,
Working on a dashboard, using a pivot chart, to identify when a ticket is transferred to a different recipient.
I'm using this CASE statement.
CASE WHEN [Constituent ID] = [Recipient Constituent ID] THEN 1ELSE 2END
Getting this error:
expecting parameter type 'Boolean' that consists of expression type 'Member Expression'. Instead found 'Demension Expression'.
Any ideas on how I would accomplish this?
This might be a case when you need to add in a (MAX [ Constituent ID]) sort of thing, to select only one Constituent ID. Does that work?
That did. Thanks! Is it possible to display a string instead of a number by any chance?
That did get rid of the error, but noticing that it's bringing back a 2 for everything, even when the IDs do not match.
Looks like this isn't supported by Sisense and they've been "working on it" for 4 years :)
Hi Jonathan,
Have you looked at the Recipient Specified Flag field?
I have not, but it looks like it does what I need. Thanks!
I'm not sure, to be honest- I've reached the end of my Sisense wizardry!