Forum Discussion

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

Quarterly Average over Weekly Average

I'm trying to create a line and clustered chart where the clusters/bars show weekly averages while the lines show quarterly averages.


Here is the measure I used to try to get a quarterly average:

Quarterly Average Talk Time =
AVERAGEX(
    SUMMARIZE(subAgentCall,subAgentCall[Quarter],subAgentCall[skill_name],subAgentCall[Call Type],"Average Talk Time",
    (SUM(subAgentCall[SUM TT])/SUM(subAgentCall[Calls Handled]))/60),[Average Talk Time])

Problem is (as indicated by the picture above), all that happens is the line matches the weekly average. Is it possible to create a measure that calculates strictly at the quarterly level and utilize it on a graph using weekly intervals?



  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    gra_wang,

     

    Drag [Quarter] on top of [Week], and select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.

10 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I am just unable to understand your requirement.  If there are data on the X-axis, then how can you show a line chart for quarters?

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

      I am trying to get the bars to indicate average talk time on a weekly level (which it is already doing), and I am trying to get the line to show the average on a quarterly level. The idea is to compare weekly to quarterly averages.

       

      Here is the raw data:

       

      For weekly average, I just used a simple measure:


      Average Talk Time = (SUM(subAgentCall[SUM TT])/SUM(subAgentcall[Calls Handled]))/60

       

      then I graphed the measure with the x-axis based on the Week column indicated in the picture above.
      Now I want to have the line show quarterly average so I am looking for a measure similar to Average Talk Time, but calculates it on a quarterly level. If a measure is not the best practice, then I am open to other suggestions. Thanks for your response. Hope this clarifies my requirement.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

        I cannot appreiate your requirement.  If weeks are shown on the X-axis then how can the line show quarterly averages?  Someone else will help you.