Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Create Table with Condition

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 o...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Hi, you can do this in Query Editor:

     

    One Way is this:

     

     

    Regards

     

    Victor

    Lima - Peru

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
vanessafvg
Community Champion
9 years ago

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