Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a Field in my dashboard that I would like to filter multiple strings of potential results.
I was thinking that the match function may be able to assist me here, but am I on the right track? If so, how would I go about only including records with A and C within a straight table?
Data Example:
Header 1 | Header 2 | Header 3 | Project Requesting Office |
---|---|---|---|
A | |||
B | |||
C | |||
A |
Regards,
Myles
In the dimension tab set the suppress null values option
In the script you can use match to load only records with these values, something like
load * from....where match(MyField,'A','C')>0
Alternatively in the front end, you can use an expression with MyField as Dimension
Only({<MyField={'A','C'}>} MyField)
or as Dimension
Aggr(Only({<MyField={'A','C'}>} MyField),MyField)
Hi Piet,
I opted to use aggr as an expression. Is there a way to suppress those null values ("-")? This would return only the records in the straight table that matter me this particular ask.
Regards,
Myles
In the dimension tab set the suppress null values option
Thanks Piet.
I didn't think to use that because i thought that the aggr function would only work as an expression.
Thanks for helping me out with this again!
Best Regards,
Myles