Forum Discussion
Resolver IIConfused how the KPI visual works.
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!
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!
rssilvabaAnonymous , 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
Anonymous , 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).
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!