1 Reply Latest reply on Jan 18, 2019 4:23 PM by Shinichiro Murakami

    Merging Two Columns into a single filter

    John Cusick

      Hi.

       

      I'm working on a visualization that will track client projects by various resources.

       

      is there a way in my datasource to have a two project fields, that i can combine into a single field in to be used as a filter.

       

      if you look at the tooltip, i have two projects (clients), and currently a filter for project and project2.  I'd really like to see if there is a way to combine the projects into a unified filter.

       

      If it helps, on my unmasked source file, i have a list of 300 projects. The column for project 2 would pull from the identical list

       

      filter.jpg