Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Measure changing based on Visualization

This has worked for the past year but now, in the new year, it is broke.  In the image I provided, I have a KPI visualization where "Operating Income FC-1" is the "Indicator".  As the "Indicator", it...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Yes move it to google drive and share from there. Make sure to remove any sensitive information your dataset have.

     

    Cheers,

    P

parry2k's avatar
parry2k
Super User
8 years ago

KPI shows based on what column you have on trend axis, if you have year on trend axis, it is showing the value of most recent year, check see data on this KPI and tht will give you the answer.

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I'm sorry but I don't fully understand your reply.  My concern is that this same exact setup of the KPI was working correctly all of 2017.  Now, 2018, it is not calculating correctly.  Could you please expand on your reply to help me figure this out.

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Yes it was working in 2017 because you have only one year. Basically it is showing you what ever the most recent year is there because you have year on trend axis. In last year because 2017 was the only year you think you were getting correct data.

     

    To test, change month on trend axis and it will show the value of most recent month in KPI.

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      basicall you have to create a measure to sum up all the year and then use that in KPI