Tabbed View, Show If expression, Unable to find column '_THISROW'

[GS1]

Hi all,

I have :

• a table called "data", including
  • a Yes/No column called "IsEHPAD"
  • a key called "_id"
• a dashboard view, including 4 tabbed detail views. 
  • Let's call them A, B, C & D
  • All based on table "data"

I try to display tabbed view D, only if IsEHPAD = yes.

When, within Show-If condition of D view, I tried :

• data[IsEHPAD]=true
  • I obtain :  Cannot compare List with Yes/No in (data[IsEHPAD] = "true")
• [_THISROW].[IsEHPAD]=true
  • I obtain :   Unable to find column '_THISROW'

----------------

Another mystery !
The column is listed, but, when chosen, I got "Unable to find column" !?!

How must I write the condition to get expected result ?

Thanks for your help

[SkrOYC]

I think you can't do what you want.

Your expression to decide if the view D should be shown is not evaluated on a row level, so Thisrow shouldn't work afaik.

I'm not sure but I think your best bet would be to make that D view based on a Slice where the data available is just the rows where [IsEHPAD] is true.

Also, you don't need to compare that column with anything, it's true by it's own

[GS1]

Thanks @SkrOYC for your suggestion.

Then following it, I  :

1. created a Slice
2. based the view on the Slice

but, it does not hide the tabbed view, as expected, only fields ;-(.


Another suggestion ?

[SkrOYC]

Well, that's the idea I had. The view (the rectangular thing with a title) will be shown, but the records aren't.

Is this a dashboard view with interactive mode turn on?

[GS1]

Turn off.

Should I turn it on ?

[GS1]

I turned it On,
it does not change the behavior

[SkrOYC]

Nope, it shouldn't. I was just asking to understand what you were trying to do.

It's weird and I don't get it yet. Why is that view there and what kind of data should be shown?

At first I though it was interactive and you where trying to see a detail view of another table

[SkrOYC]

---

@GS1 wrote:

Another mystery !
The column is listed, but, when chosen, I got "Unable to find column" !?!

---

[Joseph_Seddik]

Being not evaluated in the context of a row, does not prevent you from basing your Show if constraint on a particular value of a column in a table row. You just have to write the corresponding expression to extract this precise value. 

Do this correctly and your view should disappear as expected. 

[GS1]

Thanks @Joseph_Seddik ,

but I thought that :

• true  is the precise value
• then   [IsEHPAD] = "true"  should be the corresponding expression

Where is my mistake ?
Regards

[Joseph_Seddik]

Please show me the data source of the table where this column is located. I need to see the data please not just the columns of your tables. 

[GS1]

@Joseph_Seddik 
is this the correct method to show you the source ?

[Joseph_Seddik]

Yes, thank you. 

So the question is, among your different rows, which [IsEHPAD] will you use as the basis for the decision to show/hide the view?

[GS1]

Not sure if I understand your question.

My aim is to show the related "isEHPAD tab" within a dashboard view, 

if "isEHPAD" of the current displayed row  = yes.

Then, it depend on which is the current displayed row, no ?

OR,

should I rather answer that :

row 8, isEHPAD = yes ?
But then, I base my decision on a row, and, like all rows, its values may change, right ?

[Joseph_Seddik]

Yes, "isEHPAD" has as many values as there are rows in your table. Your expression doesn't tell which [isEHPAD] you are looking for, and this is the problem. 

So yes, you have to rephrase it as you've correctly written, "[isEHPAD] in row 8 is yes?" 

[GS1]

Thank you @Joseph_Seddik for your advice, but having finally not guessed the formula, I ended up finding a workaround.😔

[Joseph_Seddik · Accepted solution]

@GS1 I'm glad it worked even with a workaround. I just needed to understand your requirement so you won't have to guess the formula.

Anyway, I've made this attempt to implement your requirement. The conclusion is, yes you can hide and show views based on column values, but not a Details view in a Dashboard. 

Can we have Interactive mode AND event actions? - Google Cloud Community  

[GS1]

@Joseph_Seddik 

Wow, thank you for this particularly clever solution.

I never though about an indirect value, stored elsewhere !

In fact, my solution is not laptop/dashboard dedicated, then it is absolutely convenient.
Many thanks !

[Joseph_Seddik]

@GS1 Je t'en prie 🙂 ça me fait plaisir !