0

I am trying to filter a table visualization of all of my data by looking to see if a Study Number contains Activity A. If a Study Number contains Activity A then I want to filter for all rows containing those Study Numbers even if the Activity is not A. See mock data below. In my real data set I have ~55,000 rows.

I have created a calculated to return Study Numbers if Activity= A but I am not sure where to go from there. Thanks for any help.

enter image description here enter image description here

Victoria Grant
  • 35
  • 4

1 Answers1

0

If(UniqueConcatenate([Activity]) OVER ([Study Number])~="A","Y","N")

Will give you this resulting column that you can then filter on (or you can use the formula as a Data Limiting Expression:

enter image description here

Mark P.
  • 1,827
  • 16
  • 37