Forum Discussion

zaza's avatar
zaza
Icon for Resolver III rankResolver III
5 years ago
Solved

Optimizing ALLEXCEPT - Getting the next date per categories

I wrote this calculated column and it works perfectly, but the problem is that it takes way too much time to load. Question is, how can I optimize this? NextOutboundCall = VAR __call = Calls[D...
  • amitchandak's avatar
    amitchandak
    5 years ago

    zaza , Try a new column like

    minx(filter(Calls, [Customer] =earlier([Customer]) && [Date] > earlier([Date]) && [Type] = "OUTBOUND"),[Date])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

zaza , Try a new column like

minx(filter(Calls, [Customer] =earlier([Customer]) && [Date] > earlier([Date]) && [Type] = "OUTBOUND"),[Date])