Display which attempt based on dates

[michael_knight]

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	Call Type	Attempt
0001	10/10/2021	Initial	1st Attempt
0001	15/11/2021	Initial	2nd Attempt
0001	20/12/2021	Initial	3rd Attempt
0002	01/09/2021	Initial	1st Attempt
0002	10/11/2021	Review
0003	09/09/2021	Initial	1st Attempt
0003	10/10/2021	Initial	2nd Attempt
0003	12/12/2021	Review
0004	15/08/2021	Initial	1st Attempt
0005	26/08/2021	Initial	1st Attempt

It's basically looking to see if there has been any initial calls after the 1st Attempt and then display which numbered attempt it is on

I'd like this to be a custom column in the table view so I'd be able to easily filter using a silcer etc

Does anyone know how I can do this?

Please let me know if you have any questions

Thanks,

Mike

[amitchandak]

@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]

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 · Accepted solution]

@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" )