Forum Discussion

LUM's avatar
LUM
Frequent Visitor
5 years ago
Solved

Wrong calculation

Hello,   I am trying to calculate and graph the total percentage of attention of my calls, when I am creating the graph, in values, ​​I place the formula and then in the x-axis, I place the date fi...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    LUM,

     

    Try this measure:

     

    Attention% = 
VAR Callsabn =
    DIVIDE ( SUM ( Fac_Telefonia[Long Abandons] ), SUM ( Fac_Telefonia[Queued] ) )
RETURN
    IF ( NOT ISBLANK ( Callsabn ), 1 - Callsabn )

     

    Also, set the X axis to Categorical:

     

     

DataInsights's avatar
DataInsights
Super User
5 years ago

LUM,

 

Try this measure:

 

Attention% = 
VAR Callsabn =
    DIVIDE ( SUM ( Fac_Telefonia[Long Abandons] ), SUM ( Fac_Telefonia[Queued] ) )
RETURN
    IF ( NOT ISBLANK ( Callsabn ), 1 - Callsabn )

 

Also, set the X axis to Categorical: