Confused how the KPI visual works.

[rssilvaba]

Hi All, Given the attached sample.
https://drive.google.com/file/d/1iBrJRFZ9EZNg78Yei-M3yQBKPdLq1N35/view?usp=sharing 

I am trying to get the total number in the Indicator, if you look the sample you will see that I am using a distinct table for the years and with that I get the correct Indicator number for the given interval. which in the sample is '158'

This way I get the right number but then as soon as make a relationship to the calendar table or use the year number (Y#) from the calendar table the numbers goes 'blank' or wrong.

How can I get the trend to show correctly? but also have the correct amount for the period (158)?

[Sumanth_23]

hi @rssilvaba - I had to change the measure in the KPI visual and the numbers match between the 2 KPI cards. 

In the file you shared "YM#" was set to display in the KPI card; once I changed it to "Y#" then the values are matching between the 2 KPI cards. 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[rssilvaba]

@Sumanth_23 , My bad, I used the the YM# just to show that with that I get the trend.

When we change to the Y# altough we are in the Calendar table we should get the trend shouldn't we? Or am I getting this wrong? Is it because I have less than an year between the data so it can't plot the trend?

[rssilvaba]

@Sumanth_23 , Just complement, for example if I change the Trend to use the Date Hierarchy (year) instead, it does plot the trend but then I get (Blank).

[Sumanth_23 · Accepted solution]

hi @rssilvaba - The KPI visual requires data for multiple periods to show a trend and it shows the value of the key metric from the latest period vs. the target for the latest period. 

You can refer to the screen shot below for reference - you can understand the behavior better when comparing the "# Requests" vs. "KPI PA Target #" by Year & Month as a KPI visual and a bar chart

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[rssilvaba]

@Sumanth_23 , Thanks for taking the time to put this together.

I suspected that would be the case, but this makes it deadly clear.

[Sumanth_23]

@rssilvaba  - Happy to help! 🙂

[VijayP]

@rssilvaba 

Some reason I am not getting Blanks ! I am getting Values