Behaviors and its conditions

[kasa1982]

Hey Guys,

Hello world!

I need your help in this question:

I have a table  "Clients" and I've created a slice "sClients", I added the "Action" called "Check-in" that add values to another table.

Up to here it's is fine however, I need to show this Behavion only if the following condition is true:

a) The "status" column must not have the value "Initial" and the column "Date" must not be different from today's date.

The clause I'm trying is:

AND(NOT(IN("Initial", Visitas[STATUS])), NOT(IN(TEXT(TODAY(),"DD/MM/YY"), Visitas[vData])))

 Thanks in advance

[TeeSee1]

I would simply write

AND(
 [STATUS] <> "Initial",
 [vData] <> TODAY()
)

assuming

• Vistas is you Client table
• This action is created against Vistas(=Client) table
• [vData] is a Date type.

[kasa1982]

Hi Mr @TeeSee1 ,

Thanks for your reply. I forget to mention that the slice "sVisitas" is agaist my table Clients, and the table "Visits" is the condition that Iam looking for to show or hide this action.

I read data from Clients table to record it in other table, Visits.

So I want to show or not this behavior in the "Clients" table, only if there are no records found in the "Visits" table, according to the conditions I've mentioned previously.

[TeeSee1 · Accepted solution]

You can try the below

ISBLANK(
 FILTER("Visists", AND([Status] <> "INTITAL", [vDate] <> TODAY())
)

[kasa1982]

Hi @TeeSee1 ,

I made some adjustments. But bingo, works fine now.

ISBLANK(
   FILTER("Visitas", AND([STATUS] = "Inicial", [vData] = text(TODAY(), "DD/MM/YY"), [ID_VENDEDOR]=[ID_VENDEDOR])
 )
)