1 Reply Latest reply on Feb 8, 2019 10:41 AM by Patrick A Van Der Hyde

    Calculated Field using various date periods

    elisabett rico

      How do I combine the top 10 fields from a specific period of time with the top 10 fields from a different period of time? For example, I have a list of the top 10 facilities with the most incidents for Nov 18-December 18, then I have a list of  the top 10 facilities with incidents for January 19. I want one list in one table see the amount of incidents for the original top 10 facilities and any new facilities from Jan’s top 10 for the month of January. Basically comparing how the original top 10 from quarter for performed in January.