Forum Discussion

shayden's avatar
shayden
Frequent Visitor
8 years ago
Solved

Average Help

I have a reqeust to graph today's volume of calls against the 6 week historic average but only where the same Day Of Week (Monday = Monday) is averaged.  I have the following measures created, but ne...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

  • shayden's avatar
    shayden
    Frequent Visitor
    8 years ago

    Ashish_Mathur  This format worked.  I had to change some dates to reflect TODAY versus MAX('Date'), but I finally got it to work.  Thank you very much for your quick response!

     

    Average_Offered_Weekday = AVERAGEX(FILTER(DATESBETWEEN(CRM_Interval_Day_V21[CallDate],MIN(CRM_Interval_Day_V21[CallDate])-43,TODAY()-1),WEEKDAY(CRM_Interval_Day_V21[CallDate],2)=WEEKDAY(TODAY(),2)),[Total_Offered])

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      You are welcome.