Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i add a where to Straight Table ,
1)Display Results only if Column "Status"=COMPLETE
2) Might also add And , or to the above expression for different column
I sounds like dilipranjith's answer would be an ideal solution for this.
Maybe you can try putting one of the dimensions in the expressions by using the only function.
For example you want a table showing DimensionA, DimensionB, & DimensionC where Status=Complete.
You can have DimensionA & DimensionB as your dimensions and the following as an expression in your chart:
=only({<Status={'Complete'}>}DimensionC)
Let me know if that works for you.
I dont any sum expression. If only needs to display THE COLUMNS , if status=COMPLETE
ok May be i should restate my question.
Please suggest which Sheet object can be used to display rows of columns with a condition, STATUS=completed
Sory, this answer doesnt help much 😞
I sounds like dilipranjith's answer would be an ideal solution for this.
Maybe you can try putting one of the dimensions in the expressions by using the only function.
For example you want a table showing DimensionA, DimensionB, & DimensionC where Status=Complete.
You can have DimensionA & DimensionB as your dimensions and the following as an expression in your chart:
=only({<Status={'Complete'}>}DimensionC)
Let me know if that works for you.
You need an aggregation expression because otherwise you don't have a place to put the set analysis in.
But you can create a dummy one, like Sum({<Status={'Complete'}>} 1), and then hide it.
That's assuming you are using the Straight Table chart and not Table Box. For the latter it can't be done.
Alternatively, don't use Status as dimension, instead use a calculated dimension like =If(Status='Complete', Status). But I like the set analysis approach better.