Forum Discussion

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
4 years ago
Solved

Performance Against Target Measure giving weird results within Matrix

  The measure is as follows:   VAR _daysInView = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedDate])) VAR _numberOfStaff = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedBy])) -- VAR...
Need Help
  • Luuky's avatar
    Luuky
    4 years ago

    Hi SACooper, 

    What i mean is for example

    KP = (1908-1685)/1685

    LW = (494-820)/820

    MW = (1090-1572)/1572

    This should give the value I assume you are looking for.

    Greetings,

    Luuk

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
4 years ago

 

 

This is what is happens when I return _performanceAgainstTargetPercentage. So as you can see I was expecting figures such as  102.86% (1.02), -24.12% (-0.24) etc. after subtracting 1

 

** Please ignore the infinity references there are to be expected as the underlying data for that time period has yet to be captured..

Luuky's avatar
Luuky
Icon for Helper I rankHelper I
4 years ago

Hi SACooper,

What you can do is instead of doing -1 you can do - _target. In this scenario 100% = the target. Also use Divide() to divide. Hope this helps!

Greetings, 

Luuk

  • SACooper's avatar
    SACooper
    Icon for Helper II rankHelper II
    4 years ago

    Hi Luuky 

     

    in this case _Target is not 100% its a calculated numerical value. From the example above for week 25/07/2022

     

    KP = 1908 / 1685

    LW = 494 / 820

    MW = 1090 / 1572

     

    so if I take _Target away I get an extremly large number.

     

    Thank you for the DIVIDE function reminder i've replaced that element.

    • Luuky's avatar
      Luuky
      Icon for Helper I rankHelper I
      4 years ago

      Hi SACooper, 

      What i mean is for example

      KP = (1908-1685)/1685

      LW = (494-820)/820

      MW = (1090-1572)/1572

      This should give the value I assume you are looking for.

      Greetings,

      Luuk