Forum Discussion

javieezy's avatar
javieezy
Helper I
5 years ago
Solved

KPI wrong value

Hi im having a KPI problem here i've checked several posts but couldn't be able to solve my problems.    Objective: Shows YTD average of the KPI. The correct value should be:     But the I...
Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi !

    Seems like you are using KPI viusal. It has a problem, when you plot this against Date dimension or any member or Date Dimension it will show the Last Member Value of that element.

    Meanining if you plot it against Months, So it will show the KPI value for the month which is been last in the current context.

     

    To overcome this you can overlay 2 objects, 1 with Year so it will give you yearly YTD KPI value, and other with month to show monthly trend. For Yearly one you can turn off the trend axis, For Monthly one you can hide the KPI value.

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi !

Seems like you are using KPI viusal. It has a problem, when you plot this against Date dimension or any member or Date Dimension it will show the Last Member Value of that element.

Meanining if you plot it against Months, So it will show the KPI value for the month which is been last in the current context.

 

To overcome this you can overlay 2 objects, 1 with Year so it will give you yearly YTD KPI value, and other with month to show monthly trend. For Yearly one you can turn off the trend axis, For Monthly one you can hide the KPI value.