7 Replies Latest reply: Oct 9, 2015 9:13 AM by Phil Speight RSS

    Set Analysis based on Search box

    Phil Speight

      Hi

       

      I have a table of data based on hours owed by staff on a weekly basis.  At the moment this brings back all weeks for all staff.  I want to create a set analysis that only returns information for a single employee, which is determined by a manual entry (search).  I need this to be in isolation of other tables in my dashboard so it leaves them unchanged. i.e.  I cannot use a list to select.

       

      How do I do this?

       

      My data table is as follows :

       

      Week_Number,

      Staff_Number,

      Staff_Surname,

      Staff_First_Name,

      Hours_Owed,

      Unit,

      Division

       

       

      How do I do this?

       

       

       

       

      Thanks

       

       

      Phil