Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement to represent the data in better way.
The data as below.
Country | Process | Priority | Issue ID | Issue Description | Deadline | Overdue | Open Since |
IN | TCM | High | RM - India-7522 | - | 3/31/2017 | - | 27-05-2016 15:12 |
IN | TCM | High | RM - India-7651 | - | 3/31/2017 | - | 30-01-2017 06:24 |
IN | TCM | Low | RM - India-7576 | - | 3/31/2017 | - | 11-08-2016 08:43 |
IN | TCM | Medium | RM - India-7466 | - | 3/31/2017 | - | 10-03-2016 12:18 |
IN | TCM | Medium | RM - India-7589 | - | TBC | 153 Days | 02-09-2016 14:28 |
IN | TAX | Medium | RM - India-7542 | - | 1/31/2017 | 2 Days | 13-07-2016 17:03 |
IN | TAX | Medium | RM - India-7543 | - | 3/1/2017 | - | 13-07-2016 17:08 |
IN | TAX | Medium | RM - India-7544 | - | 1/31/2017 | 2 Days | 13-07-2016 17:15 |
IN | TAX | Medium | RM - India-7545 | - | 1/31/2017 | 2 Days | 13-07-2016 17:18 |
IN | TAX | Medium | RM - India-7546 | - | 1/31/2017 | 2 Days | 13-07-2016 17:35 |
IN | TAX | Medium | RM - India-7551 | - | 1/31/2017 | 2 Days | 29-07-2016 13:13 |
IN | TAX | Medium | RM - India-7552 | - | 1/31/2017 | 2 Days | 29-07-2016 13:15 |
IN | TAX | Medium | RM - India-7553 | - | 1/31/2017 | 2 Days | 29-07-2016 13:19 |
IN | TAX | Medium | RM - India-7554 | - | 1/31/2017 | 2 Days | 29-07-2016 13:21 |
IN | TAX | Medium | RM - India-7555 | - | 1/31/2017 | 2 Days | 29-07-2016 13:23 |
IN | TAX | Medium | RM - India-7556 | - | 1/31/2017 | 2 Days | 29-07-2016 13:34 |
IN | TAX | Medium | RM - India-7557 | - | 1/31/2017 | 2 Days | 29-07-2016 13:36 |
IN | RtR | Medium | RM - India-7399 | - | 7/31/2016 | 186 Days | 09-02-2016 06:41 |
IN | PtP | Medium | RM - India-7483 | - | 12/31/2016 | 33 Days | 09-11-2016 10:22 |
IN | MDM | Medium | RM - India-7586 | - | 9/10/2016 | 145 Days | 29-08-2016 11:46 |
IN | MDM | Medium | RM - India-7587 | - | 9/15/2016 | 140 Days | 29-08-2016 14:37 |
Requiremnet as below:
1.We need to count the no .of issues based on Country/Process and out of total number issues we need to show how may are of them are of High/Medium/Low priority and from the subset we need to show how many issues have met the deadline.
For example:
For Country IN:
Issues are 21
and there are 3 Unique Process
Out of 21 issues
High 2 and all these Issues have met the deadline
Low 1 and all these Issues have met the deadline
Medium 18 out of which 2 Issues have met the Deadline and 16 issues not met the dead line.
Also if you can show the Bucket for the issues which have not met the deadline like Issues which have met the dead line =1 day to 10 and >10days to <=20 days and so on.
I need to show the above requirement in chart.
Awaiting for reply.
Thanks
Sk
please promote bucket dimension, i forgot to promote
SO in final chart, you need to show how many meet the deadlines and bucket column?
Which column is indicating that the deadline is met in your sample data?
Hi,
Actually Yes.
The column will be overdue.
If overdue is Null then the issue has met the dead line and if not based on the bucket we have to represent the data.
May be this?
please promote bucket dimension, i forgot to promote