Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
4 years ago
Solved

Display which attempt based on dates

Hi All,   I'm trying to display which attempt we're on in terms of booking people in for Initial calls. I've inputted a table below of what the expected resuls will be Membership Call Date Ca...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    michael_knight , I do saw any first call in your result column

     

    I think a new column like 

    Var _1 = Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])

    return

    if(_1 =1, "1st Call", (_1 -1) &  " Attempt" )

     

amitchandak's avatar
amitchandak
Super User
4 years ago

michael_knight , A new column like below will give you number

Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])

 

You can convert 1 ->1st, 2-> 2nd

michael_knight's avatar
michael_knight
Post Prodigy
4 years ago

Hi amitchandak, thanks for the reply. I tested that measure and it looks like it only counts the number of times a call has been attempted to be booked in. I'm looking at going into more details, for example if the call is the 1st call then return 1st Attempt, if it's the 2nd call then display 2nd Attempt and so on

 

Does that make sense?

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    michael_knight , I do saw any first call in your result column

     

    I think a new column like 

    Var _1 = Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])

    return

    if(_1 =1, "1st Call", (_1 -1) &  " Attempt" )