I have an interactive dashboard where I want ...

expressions
(Twenty West KC) #1

I have an interactive dashboard where I want to show action buttons based on the value in a currently selected column. I am currently using the expression:

CONTAINS([_THISROW].[LEASE], “Arnold”)

I want to replicate this where the quotations matches each value contained in the [LEASE] column. Currently, this is not displaying the action button, even when the value of the current row selected for the lease column = “Arnold”. Am I using the wrong expression, or just approaching this the wrong way?

(Steven Coile) #2

Does CONTAINS([_THISROW].[LEASE], “Arnold”) work as desired?

(Twenty West KC) #3

@Steven_Coile it does not

(Aleksi Alkio) #4

CONTAINS([LEASE],“Arnold”) should be enough.

(Steven Coile) #5

@Twenty_West_KC Try removing [_THISROW]., it shouldn’t be needed: CONTAINS([LEASE], “Arnold”)

(Twenty West KC) #6

@Steven_Coile I tried it that way as well but still couldn’t get the action button to show up

(Steven Coile) #7

@Twenty_West_KC Can you give me an example of a [LEASE] value (preferably one you would expect to match with that contains() expression)?

(Twenty West KC) #8

Basically any of the [LEASE] values are text values, “Arnold”, “Barger”, “Pena”, etc.

(Steven Coile) #9

@Twenty_West_KC Okay, so the contains() expression (without [_thisrow].) should work fine. Did you try to Test it from EXPRESSION ASSISTANT (NEW!) when entering it? That might provide some insight.