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

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

 

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

 

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

  • 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