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
  • dramus's avatar
    dramus
    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi JCovelli,

 

Do you have timestamp as well in your data or just days? 

 

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

    Hello!

    I get the data from a SQL query, and there is a time date field with a time stamp in it.  I usually do ,CAST(INTERACTION.PXCREATEDATETIME as DATE) so that I can group by DAY in a pivot table, but I can alos just leave it with the timestamp in it.

     

    Thanks!

     

    John

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi JCovelli,

       

      Do you want to count the number of calls made in the same day as frequent calls or just on multiple days?

      • 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.