Forum Discussion

jgilbert's avatar
jgilbert
New Member
3 years ago
Solved

Report Server KPI Status

I am trying to create a dataset to control the status (red, green) of a KPI widget. I used the below query (minus count from year 1 YTD and year 2 YTD) hoping that just being a negative or positive n...
KPI
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jgilbert ,

    In Report Server Portal,when you create a KPI, ou could set "Status".This field compares the key performance indicator value and goal scores. It has only three options -1 bad, 0 (neutral) and 1 (good). At the same time, this values changes the color of the KPI.

    For more details, you can read related document: How to automatically create KPIs in SQL Server Reporting Services (sqlshack.com)

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jgilbert ,

In Report Server Portal,when you create a KPI, ou could set "Status".This field compares the key performance indicator value and goal scores. It has only three options -1 bad, 0 (neutral) and 1 (good). At the same time, this values changes the color of the KPI.

For more details, you can read related document: How to automatically create KPIs in SQL Server Reporting Services (sqlshack.com)

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.