Hello,
I'm creating a visualization that aims to show orders that have a specific piece of equipment in it. My database has multiple rows of 'SO #', 1 row for a different type of equipment ordered. I want to see how many orders out the total have number '100' in column 'Equipment #'. In other words, for each 'SO #' I want to mark it as a 1 if it includes '100' in column 'Equipment #' and 0 if it doesn't include '100'.
Thanks!!