Create Table with Condition

[Anonymous]

Hello Guys, need your help.

Imagine I have the following table, giving Bugs by date and if they are still open (not fixed) or not.

So in this table I want to exclude Bugs that were never opened, but for the ones opened, I want to see the row appearing when they were closed. were never had a value of Open = 1.

Thanks!

[Vvelarde · Accepted solution]

@Anonymous

Hi, you can do this in Query Editor:

One Way is this:

Regards

Victor

Lima - Peru

[vanessafvg]

@Anonymous Table = CALCULATETABLE('Table', IsOpen = 1 )

unless i am missing something all you need to do is filter on isopen = 1

[Anonymous]

Ups, I think I forgot to mention that I do not wish to lose the rows were they were closed.
That way those rows will be filtered out no ?

I want a table that will show me all rows for Bugs that were once open, but I want the row showing when they were closed.
So in this table I want to exclude Bugs that were never opened, but for the ones opened, I want to see the row appearing when they were closed. 

Made a big fuss

[vanessafvg]

@Anonymous

create a calculated column on the table

indicator= calculate(values[bug], open = 1)

then 

newtable = CALCULATETABLE('Table', filter(table, indictator <> blank())

 haven't tested it