How to show nested table column by using behavior

I am making task management app. Some tasks are flow, so I made 4 columns, "Unique ID", "Thing", "After", "Before". "Before" is virtual column.

Actual data is like below

amufaamo_0-1656329315210.png

 

Expression of "After" is below. I can choose rows.

amufaamo_1-1656329315448.png

 

The expression of "Before" is below.

select(not done task[Thing], in([_thisrow].[Thing], [after]))

amufaamo_2-1656329315279.png

 

When I select "Eat breakfast" row, I can see the tables of "make coffee" and "make bread".

amufaamo_3-1656329315465.png

 

I want to make view if I select "Eat breakfast", I can directly see the list of "make coffee" and "make bread".

I tried to make slice, the expression is below, but it shows nothing. Is something wrong?

IN([Thing], [_thisrow].[Before])

 

So sorry it is quite long sentence

0 1 128
1 REPLY 1

I don't see what is wrong but I believe you want "Before" to just be a single value.  Currently the SELECT() returns it as a list of values.  I would recommend using this slight modification and change the column data type to Text:

ANY(select(not done task[Thing], in([_thisrow].[Thing], [after])))

For the slice, you then want to change it so that it checks if [Thing] is in ANY of the Before columns for the entire table.  Something like this:

IN([Thing], UNIQUE(not done task[Before]))

I include the use of UNIQUE() to keep the returned list as small as possible for efficiency 

Top Labels in this Space