4 Replies Latest reply on Jul 22, 2019 7:55 AM by Paul Wachtler

How to show a KPI in percentage?

Abhijit Nikhade Jun 19, 2019 7:09 AM

I need to convert the KPIs Immediate Action, Next Opportunity and Overdue Repairs (shown in the picture below) into the percentage of open cases.

I would like to show these percentage KPIs instead of the numbers I am showing on dashboard "Dash-KPI-All". I have attached the sample workbook here. I have created the calculated field "percentage_of_immediate_action_cases_CMS" with all the conditions. But looks like its throwing NULL value and not displaying it properly. I tried do display the same on sheet "Test_Page" as most of my KPIs are being calculated as a separate sheet. How to achieve this? Also, I want to show the percentage symbol in KPIs as well.

Appreciate the help from community.

Best,

Abhijit

Pulse_Point_20190619_sample.twbx 13.4 MB

1. Re: How to show a KPI in percentage?

Matt Lutton Jul 19, 2019 10:12 AM (in response to Abhijit Nikhade)

Have you attempted to use Table Calcs? More details may be helpful here.
Like Show 0 Likes(0)

Actions
2. Re: How to show a KPI in percentage?

Paul Wachtler Jul 20, 2019 2:47 AM (in response to Abhijit Nikhade)
Hi Abhijit,

I added percentages for those three metrics on the CMS side. You can replicate this on the SCADA side.

Now they add up to more than 100% because they're calculated using different things. Immediate Action and Next Opportunity are based on your case_priority field, whereas Overdue Repairs is based on the is_overdue_repairs field. I created calculated fields to figure out the percentages and then removed your filters from the individual worksheets. Here's what it looks like with those three fields as percentages:

This is in the updated attached workbook.

Best,
Paul

Pulse_Point_20190619_sample_updated.twbx 13.4 MB
Like Show 1 Likes(1)

Actions
3. Re: How to show a KPI in percentage?

Abhijit Nikhade Jul 21, 2019 8:47 PM (in response to Paul Wachtler)

Thank you Paul! This is helpful.
Like Show 0 Likes(0)

Actions
4. Re: How to show a KPI in percentage?

Paul Wachtler Jul 22, 2019 7:55 AM (in response to Abhijit Nikhade)

Welcome! Happy to help!
Like Show 0 Likes(0)

Actions