Forum Discussion

gra_wang's avatar
gra_wang
Helper 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 avera...
  • 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.

gra_wang's avatar
gra_wang
Helper I
8 years ago

I have modified the formula for the measure:
Quarterly Average Talk Time =
CALCULATE(
    SUMX(
        SUMMARIZE(subAgentCall,subAgentCall[Quarter],subAgentCall[skill_name],subAgentCall[Call Type],"Quarterly Talk Time",
        (SUM(subAgentCall[SUM TT])/SUM(subAgentCall[Calls Handled]))/60),[Average Talk Time]),ALLSELECTED(subAgentCall[Week]))

 

and I dragged [Quarter] into the shared axis. Unfortunately, I am still not getting the desired result:

The line values are different, but I am still getting a constant line instead of a line that changes as the quarter changes.

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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.

  • gra_wang's avatar
    gra_wang
    Helper I
    8 years ago

    Thanks for your help thus far.

     

    Is there a way to hide the quarter axis label?

     

    Here is how my x-axis labels look right now: