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!
Resolver IIAnonymous , 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?
Resolver IIAnonymous , 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!