+ Reply to Thread
Results 1 to 2 of 2

Non Numeric data representation in a dashboard

  1. #1
    Registered User
    Join Date
    06-14-2018
    Location
    Auckland, NZ
    MS-Off Ver
    2010, 2016
    Posts
    1

    Non Numeric data representation in a dashboard

    Hi Excel'ers

    I have been asked to create a KPI dashboard and have immediately hit a road block.

    Context: I work in a contact center, my TL would like a dashboard that presents the following information:

    Five areas of monitoring (Underwriting, Phone communication, written communication etc.)

    Within the five areas there are eight categories that will have a YES, NO or N/A answer. For example for the written communication area:

    1. Has the consultant used the clients name: Yes, no or N/a
    2. Has the consultant used correct spelling: Yes, no or N/a
    etc.

    Data

    I will have a data worksheet that will display a score card. My TL will enter a 1 for Yes or 0 for No (if this is the best way)

    Issues

    My question to you, is how do I represent non numeric data on a dashboard? Would I assign an value for Yes and 0 for No and then total the values up and use these in the formulas? E.g. 5 Yes's and 3 No's means a total of 5 points out of potential 8. Is there another way that is better?

    Also, she would like to have some sort of SWOT analysis built into the DB, is this even possible based on the data?

    Are there any other issues you can see?

    Thanks in advance!

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,291

    Re: Non Numeric data representation in a dashboard



    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything
    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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