Forum Discussion
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 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!
Anonymous
Hi, you can do this in Query Editor:
One Way is this:
Regards
Victor
Lima - Peru
4 Replies
Anonymous Table = CALCULATETABLE('Table', IsOpen = 1 )
unless i am missing something all you need to do is filter on isopen = 1
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 fussAnonymous
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
Anonymous
Hi, you can do this in Query Editor:
One Way is this:
Regards
Victor
Lima - Peru
