Charting Issues with Decimal Minutes

[i820017]

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

[Anonymous]

Hi @i820017,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[i820017]

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

[Ashish_Mathur]

Hi,

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

[i820017 · Accepted solution]

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]

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