0

I am trying to analyze a data set that has nested data. I have a column that contains projects, a column that contains activities of those projects, and dates that those activities were completed. I want a way to filter by projects, and then after that filter by the date of activity completion.

Here is an example of what I have (filtered by project):

Projects | Activities | Dates

Project #1 | Activity #3 | Date

Project #1 | Activity #1 | Date

Project #1 | Activity #2 | Date

Project #2 | Activity #2 | Date

Project #2 | Activity #3 | Date

Project #2 | Activity #1 | Date

Project #3 | Activity #3 | Date

Project #3 | Activity #2 | Date

Project #3 | Activity #1 | Date

Here is what I want to achieve (filter by project and activity):

Projects | Activities | Dates

Project #1 | Activity #1 | Date

Project #1 | Activity #2 | Date

Project #1 | Activity #3 | Date

Project #2 | Activity #1 | Date

Project #2 | Activity #2 | Date

Project #2 | Activity #3 | Date

Project #3 | Activity #1 | Date

Project #3 | Activity #2 | Date

Project #3 | Activity #3 | Date

I want to make a table that looks like this so I can design a column that shows the distance between the dates of the activities completed. I then want to use these distances to make a chart showing the average number of days between the activities. I feel as if I cannot do that without sorting with the method mentioned above. Can anyone point me in the right direction to accomplish what I am looking to do?

Keith Miller
  • 1
  • Hi Keith, Can you clarify a little more please? Specifically, for what purpose will you use the charts that you are looking to create? - This might help us to provide more useful suggestions in our answers. – Iain9688 Jul 03 '20 at 13:30

1 Answers1

1

Easy one. Just put your data into a spreadsheet software like Excel or Lotus Notes. Put a nice filter around your data then sort by date and then sort by project.

This way you have a list that is primarily sorted by project and secondarily by date ;)