2 Replies Latest reply on Nov 16, 2010 2:37 PM by Edwin Lindeman

    Jobs Reports

    Edwin Lindeman
      Share This:

      Needing some feedback if I'm going down the right path.  I'm building a cross-tab report where column is Job Type Name and Rows is Run By Role. There is a particular to the naming convention of the Run by Role so instead of showing the actual name of the Role Name i substring the name out using the first 4 characters of the Role which shows the department that role is from.  My objective here is to show how many jobs were ran by a particular department in each of the Job Types. I will be filtering this out by Year and Month when the job was ran.   Where I'm having difficulties is the measurement. I'm not sure if I should use Job #? Count(rows) to put in the measurement.    Easier way of doing this?