Tableau - How to graph two different filters of the same dimension

Question

I want to make a line graph of the amount of debris in water vs the number of boating accidents. But they both fall under the same dimension "Event Description" just as different filters "Water Debris" and "Water Emergencies".

So in my worksheet, I put "Event Description" in both the Rows and Columns with a "Number of Records" Measure in each. However when I try to separate the filter for one "Event Description" it changes the filter for both.

I am very new to Tableau so I'm probably missing something obvious but any help would be appreciated.

Answer 1

I'm taking a guess at your data structure and ultimate goal with this but you are able to separate out each event as its own dimension.

Water Debris = 
IF [Event Description] = 'Water Debris' THEN 1
END

Water Emergencies = 
IF [Event Description] = 'Water Emergencies' THEN 1
END

You can then add these to a scatter plot or other type.