2 Replies Latest reply on Feb 10, 2019 8:40 PM by trina fitzpatrick

    Filter concatenated field

    trina fitzpatrick

      I have a field that is concatenating seasons separated by commas.  I am looking for a way to filter for specific seasons.  For example I would like the filter to have the options of:

       

      Season

      FA18

      SP18

      HO18

      All

       

      So if the Season field contained both FA18 and SP18, then this data would show up when either filter was selected. 

       

      Example of data field

      FA18,HO19,SP18,SU20,HO18