Forum Discussion

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago
Solved

“Frequent Caller” metric

Hello Group! Does anyone know how I might use DAX or Power BI to calculate our “Frequent Caller” metric here at work?… we say that anyone of our members who has called us more than one time in a wee...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

     

    I created a new summarize table:

     

    Last Called = summarize(Calls,Calls[Caller],"Last Called",max('Calls'[Date]))

    Then I added a new Column:

    Frequent Caller = if(countx(filter(Calls,datediff([Date],'Last Called'[Last Called],DAY)<=7 && [Caller]='Last Called'[Caller]),[Caller])> 1,"Yes","No")

    Here's a pic of the report.

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago

hmm... thats a good question... sometimes a caller might hang up and call right back, so It may be better to exclude calls made within the same day.. or within 30 minutes of each other... etc.

 

if this makes things too difficult with the calculation, then we could count include calls made in the same day.  

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi JCovelli,

 

To look at all the users who called on multiple days, you could create a measure Frq = DISTINCTCOUNT(Table[Date]). Then create a table visual with column User and Frq. Any row greater than 1 would be your frequent callers.

  • JCovelli's avatar
    JCovelli
    Icon for Helper I rankHelper I
    8 years ago

    Hmm, but how could one tell between members who have called more than one time, versus those who have called multiple times withint a 7-day period?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       

      I created a new summarize table:

       

      Last Called = summarize(Calls,Calls[Caller],"Last Called",max('Calls'[Date]))

      Then I added a new Column:

      Frequent Caller = if(countx(filter(Calls,datediff([Date],'Last Called'[Last Called],DAY)<=7 && [Caller]='Last Called'[Caller]),[Caller])> 1,"Yes","No")

      Here's a pic of the report.

      • JCovelli's avatar
        JCovelli
        Icon for Helper I rankHelper I
        8 years ago

        This looks very interesting! I am also a beginner in alot of ways with this stuff, so please forgive the questions.

         

        1. If you added some call instances for your Caller 3, for example a call on 1/12, another on 1/13, and another on 1/29, would the system you designed show Caller 3 as a Frequent Caller "Yes"

         

        2. Would it show the number of calls within a 7-day period to be 3? 1/12, 1/13, and 1/15 and NOT include the call on 1/29?