Forum Discussion
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 | 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
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" )
3 Replies
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
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?
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" )
