How to hide block in a break with some condetion
I have 3 columns, ANI Repeat calls, Start time of the call in a webi report. I have repeated calls from same ANI at different starts times. I need to show ANI's which are repeated in different start times for same day. Can you please help us get the Repeated Calls form same ANI at different start times.
Please find the attached screenshot, where i need to get the calls form ANI 5555555555 Repeated calls=3 and I need to show them only repeated ANI's (Repeated Calls >=2)
SriHarsha T replied
Create a variable with the below formula and apply filter on that.
This formula gives you the repeated calls for every ANI. For ANI 5555555555 the variable will give you the value 3.
Apply the filter on the variable >=2.
Or also you can do it using the below formula too
=[Repeated Calls]ForAll([DNIS];[LOB];[Call End Reason];[Call End Location];[StartTime])