Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have these columns:
Employee ID | Dates | Location |
---|---|---|
123 | 1/1/2016 | San Jose |
123 | 1/2/2016 | San Jose |
123 | 1/5/2016 | Seattle |
123 | 1/6/2016 | San Jose |
I want a Table that shows me data in this format:
Location Name | Employees with more than 2 days of travel in Location |
---|---|
San Jose | 1 |
Seattle | 0 |
I am struggling with the last column 'Employees with less than 30 days of travel'. Can someone help?
I don't see that column in your example. If it should be in the 2nd table I'm not exactly sure how you want to display this as this table is based on location and not on employee.
I'll try to help if you can provide more information.
What expression did you use to get 'Employees with more than 2 days of travel in location'?