LinkedIn
Twitter
Hi everyone.
This is my first day here, so I tried hard to find an existing thread about my question, but no luck.
My company have sales representatives working from home, so we at HQ want to see their first phone call of the day, (and maybe the last) at a later time.
I managed to get the first call of the day of ANY seller, but not for each one individually.
As you can see from the picture. All the names has the same time stamp for first call.
How do I get everyones First call.
I used this question to get the first call.
index(${phone_call_extended.date_time_of_day},min(if(NOT is_null(${phone_call_extended.date_time_of_day}), row(), null)))
I have been stucked at this issue for a week now.
Can anyone help. Dont hav SQL in my version of looker.
