Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to capture the non-compliant outreach attempts by Tier. This means I'm looking into the 2 date columns [DTLastAttemptContactFam] and [DtLastSuccessfullContactFam] and seeing if the date of contact was in the same month as the report date [reportdt] . I also need to filter by the column [Tier-TierNum] for '2'. I am looking for the instances of NO CONTACT in either of those date fields. If one has contact but the other doesn't then it is ok and I do not need it returned in results.
I am doing a table and trying to maybe do a pull down filter on [reportdt] which would ensure all data was the same month which is why GetFieldSelections is included.
Below is what I have but I'm getting zero which isn't correct:
Count({<[Tier-TierNum]={'2'}, GetFieldSelections, DtLastSuccessfullContactFam<{'month(reportdt)'},[DTLastAttemptContactFam]<{'month(reportdt)'}>}[Tier-TierNum])