Excel dashboard

Ends 28 Feb 2018 (in 3 months)

I would like to my incident form which has 20 columns to be presented in a Dashboard format.
I want the following things to be done.
Create a Dashboard with the data in bar graphs form showing the following data
1. The number of issues raised by issue.
2. The number of repeat issues.
3. The number of issues by product/platform
4. The count of service affecting (Y/N)
5. The number of issues raised by priority
6. Number of issues resolved at first call
7. Count of repeat issues by product/platform
8. I want to be able to filter the above data by quarter( june, july, august - Q1, Sept, Oct, Nov -Q2, Dec, Jan and Feb -Q3...e.t.c
The most important of all this.
I want the first quarter to be given an index value of 100. For subsequent quarters, the scores are calculated as follows, (Issues on current quarter/issues in Q1) X 100. In this way we can see if the incidents are increasing or decreasing.
Please create a different tab for the Dashboard. Look and feel of the Dashboard is important. I want to be able to affix a logo somewhere on the Dashboard area to look nice (I can affix the logo myself) so create a place for this.

Sign up to apply →

Posted on peopleperhour.com

Know a freelancer that can do this job?

Earn lifetime commission for every freelancer you refer, by becoming an affiliate. Find out more

Share this job: