I want to only show records that have specific values

[#1]

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

[stigchel]

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)

[#3]

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

[stigchel · Accepted solution]

In the dimension tab set the suppress null values option

[#5]

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