Return records created within past 11 hours?

So the report needs to have the following constraints.

  1. Call created by current user
  2. Call created in the past 12 hours.
  3. Count of calls by sales rep (there’s 7 reps).

Does that make sense?

So, the output would look like

Chris: 7
Chuck: 9
Jerry: 2
Tim: 4
Jim: 7
Tyler: 10
Jared: 1

Is the number of sales rep (7) a known value that will be fixed ?

If so, the above solution will do what you want, you will just have to duplicate it, once for each sale rep (your app in in read-only mode so I can’t do it for you, but try it should work)

Yes, it’s fixed.

What solution will work? My current solution doesn’t work.

Can you switch your app settings so that I can edit it to show you ? I won’t break anything I promise :slight_smile:

Done, go for it.

Look at it, I did it for #6 and #7 only.
It is a bit tediuous to do but it should work :slight_smile:
I would also recommend that each “Do a search for Sales Rep” you do is sorted by unique id to be sure the list is always in the same order

Ok looks like it worked. I need to input some more test data to see.

It looks like I was trying to make it more complex then it was.

Do you mean sort by unique ID for the search that it returning the count?

or I was supposed I’d be to sort them both so that get “:item7” would return the same one.

Also, thanks for your help!

I mean that each search called “Search for Sales Rep”, the one for the name, and the one inside the search for calls, should be sorted by unique id.
Maybe I am paranoid but that way you are sure that hen you call item #7 to display the name, this is the same item #7 you get in the search for calls…

I get it, I agree, this is good quality control. Thjanks for your help!

You are welcome :slight_smile:

@topherwilliams if the number of reps becomes unfixed, you might consider the Toolbox plugin’s List Item Expression.

Edit: whoops it doesn’t suit this particular case of call counts.

@mishav thanks for the help!