1 Reply Latest reply: Jun 2, 2015 12:57 PM by Sunny Talwar RSS

    Set Analysis Question - Filter Me & My competitors from 1 field?

    Matt Mohon

      I have a field of "salesperson" and I want that to be a filter to hone in on who the report audience is for.  I also want them to be able to pick peers to compare to, but technically it's out of the same field.  I've accomplished this but adding an additional field called peer_salesperson, which is actually the exact same data, just duplicated in another field.

       

      This way I can use list boxes to filter on:

      [salesperson] Who the Report is for

      [peer_salesperson] Who I'm comparing against

       

      Am I doing this correctly? Or is there a set analysis way to do this all from one field?

       

      I'd like to do this for a date range as well to determine an analysis period, and a baseline period.