1 Reply Latest reply on Sep 19, 2016 9:33 AM by lenaic.ridinger

    Data with different dates

    Sanjay Mistry

      Hello all,

       

      I am trying to bring different measures on the same worksheet – Jobs, offers, submission, hires etc.

      image 1.png

      image 3.png

       

      The day a job created is recorded under Created Date in Requisition table. Hires coming from Placement table which has Start Date. Placement doesn’t have Created Date. Other measures are in a separate table. They all have their own created date as shown above.

       

      In the reports, managers would like to see number of Jobs and other measure, let's say from 1/1 to 7/29. The challenge is that after a person is hired, he/she may not start within the time frame of 1/1 to7/29. Hence, the count doesn’t show up.  The other columns you see above have the same challenge. One way I was able to put it all together is by creating separate sheets and bring them under Dashboard. Not the most ideal, but it works. (see below)

      image 2.jpg

       

      What is the best way to do bring all columns in one report?

       

      Thanks,

       

      Sanjay