+ Reply to Thread
Results 1 to 3 of 3

Best way to show low data for performance management?

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Best way to show low data for performance management?

    Hi guys

    Anybodyu got experience of showing low performance:

    I..e An indivudal makes 5 out of 700 errors. How would you suggest this is presented? currently i would do 5/700 * 100

    But it seems to be presented as too low. Any other suggestions on how i could present this differently? i am just trying to find a good way of presenting it

    thank you!
    Thanks,

    R.



  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Best way to show low data for performance management?

    I do not know what you exactly want to present.
    If your data is too low, so maybe instead of present it as number, present it as percentage related to other results.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: Best way to show low data for performance management?

    If you allow an individual up to say 50 errors to make 1. Then 5 out of 700 errors should be presented as 5*50/700*100% = 36%.
    Last edited by josephteh; 07-04-2020 at 09:50 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-11-2020, 12:59 PM
  2. Excel Performance: Tips for optimizing performance obstructions
    By dangelor in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-06-2019, 06:33 PM
  3. current moth MTD performance with last year same month same days performance
    By satyanarayana in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2015, 03:36 AM
  4. Create An All In One Performance Management Workbook
    By pringle1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2014, 04:54 AM
  5. Replies: 2
    Last Post: 09-07-2012, 05:39 AM
  6. Data Management
    By Mordred in forum The Water Cooler
    Replies: 17
    Last Post: 06-15-2011, 05:31 PM
  7. VBA autoshape arrows to show performance
    By mikeyfear in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-02-2008, 08:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1