Does anyone know how I could create a time search ...
# suiteanalyticsn
Nicolas Bean
10/15/2020, 1:55 AMDoes anyone know how I could create a time search that would eliminate any employee that has a timesheet >= 44h for last business week? (aka grouped by employee, sum the time, then eliminate the ones that are < 44h)
b
battk
10/15/2020, 1:59 AMlook at the summary subtab under your criteria tab
n
Nicolas Bean
10/15/2020, 2:04 AMi have, but how would I do that? this has really been a head scratcher
Nicolas Bean
10/15/2020, 2:05 AMI guess I should be more specific- I did achieve it but I wanted to expose more fields (project - grouped)
Nicolas Bean
10/15/2020, 2:05 AMand it messed with the results as the sum was not working properly anymore
b
battk
10/15/2020, 2:07 AMbasics is that summary criteria use the same grouping as your columns
battk
10/15/2020, 2:07 AMuse the summary columns to group your search results
battk
10/15/2020, 2:07 AMand the summary criteria to add criteria on those groups of search results
n
Nicolas Bean
10/15/2020, 2:13 AMyeah I get it.. it just seems like its a sum of a sum though
Nicolas Bean
10/15/2020, 2:13 AMdon't know if that's possible
b
battk
10/15/2020, 2:15 AMno sums of different groups
n
Nicolas Bean
10/15/2020, 2:16 AMlets say I have:
Employee 1 Project 1 40
Employee 1 Project 2 10
Total = 50 >= 44
Nicolas Bean
10/15/2020, 2:16 AMgrouped by employee & project, and the 40 & 10 are the result of a formula
b
battk
10/15/2020, 2:17 AMsummary criteria wont let you group by employee and employee/project
battk
10/15/2020, 2:17 AMyou get one or the other
battk
10/15/2020, 2:19 AMyou can try using the analytic form of sum in a formula, but ive never had much luck using those in criteria
n
Nicolas Bean
10/15/2020, 2:19 AMyeah...
Nicolas Bean
10/15/2020, 2:19 AMok thank you i'll give that a shot
b
battk
10/15/2020, 2:20 AMexpect to do some weird stuff to your formula
n
Nicolas Bean
10/15/2020, 2:21 AMinteresting
m
michoel
10/15/2020, 3:00 AMI'm pretty sure it's not possible to use an analytic function in criteria
👍 1
2 Views