Forum Discussion

i820017's avatar
i820017
Resolver II
5 years ago
Solved

Charting Issues with Decimal Minutes

Hey Everybody,

I am trying to graph an average for a column entitled TalkTimeAvg__Column vs CallMonth as a line graph, and it is graphing an overall total instead of an average.

 

Here is the formula for the TalkTimeAvg__Column

TalkTimeAvg__Column = DIVIDE([TalkTime_Sum], [ACDAnswer_Sum], BLANK()) / 60
 
Here is a snapshot of the TalkTimeAvg__Column

 

 
 
For 'Axis', I put in 'CallMonth'....For 'Values', I put in 'TalkTimeAvg__Column' to create the line graph
 
Here is a snapshot of the graph that I am getting.

 

 

The issue is that the Y-Axis should be showing an average between 1 and 10 for all of the employees for each month. Instead it is showing a sum.

 

Does anyone know how to fix this?

 

Thanks

Dan

Need Help
  • i820017's avatar
    i820017
    5 years ago

    I just used a measure instead of a calculated column, and the Y-Axis is still an overall sum instead of a number between 1 and 10.

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    I think you are getting confused between calculated column and measure.  Share the link from where i can download your PBI file.

    • i820017's avatar
      i820017
      Resolver II
      5 years ago

      I just used a measure instead of a calculated column, and the Y-Axis is still an overall sum instead of a number between 1 and 10.

      • i820017's avatar
        i820017
        Resolver II
        5 years ago

        I just re-did my measure, and it works now...thanks!!

         

    • i820017's avatar
      i820017
      Resolver II
      5 years ago

      I changed the calculated column to a measure, and it worked.