Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
T1:
Id | Name | Status | Risk | Date |
100 | ABC | Open | Low | 10/1/2014 |
100 | ABC | Closed | Medium | 3/2/2014 |
200 | DEF | Open | Low | 1/1/2015 |
200 | DEF | Open | Medium | 1/2/2015 |
200 | DEF | Closed | High | 1/3/2015 |
300 | XXX | Open | High | 5/6/2015 |
300 | XXX | Open | Low | 7/7/2015 |
300 | XXX | Closed | High | 8/9/2015 |
400 | YYY | Open | Low | 1/2/2015 |
400 | YYY | Closed | Medium | 2/2/2015 |
500 | ZZZ | Open | Low | 2/3/2015 |
100 | ABC | Closed | High | 3/5/2014 |
100 | ABC | Closed | Medium | 3/3/2014 |
200 | DEF | Closed | Low | 1/4/2015 |
I have a Table T1 with above mentioned data
we need to show the Risk for a Id changes from when we first receive the Id's risk in the above table to when their Status changes to Closed
A flag needs to be added to know risk changes or not
Output:
Id | Name | Status | Risk | Date | Risk_Flag |
100 | ABC | Open | Low | 10/1/2014 | N |
100 | ABC | Open | Medium | 3/2/2014 | Y |
100 | ABC | Open | High | 3/5/2014 | Y |
100 | ABC | Closed | Medium | 3/6/2014 | Y |
200 | DEF | Open | Low | 1/1/2015 | N |
200 | DEF | Open | Medium | 1/2/2015 | Y |
200 | DEF | Open | High | 1/3/2015 | Y |
200 | DEF | Closed | Low | 1/4/2015 | Y |
300 | XXX | Open | High | 5/6/2015 | N |
300 | XXX | Open | Low | 7/7/2015 | Y |
300 | XXX | Closed | High | 8/9/2015 | Y |
400 | YYY | Open | Low | 1/2/2015 | N |
400 | YYY | Closed | Medium | 2/2/2015 | Y |
500 | ZZZ | Open | Low | 2/3/2015 | N |
Please help me to get the above output.
ID | Fixed | Status | Test_Date | values | Date |
100 | N | approved | 8/8/2016 | Text | 8/8/2016 |
200 | N | approved | 26/05/2016 | Text1 | 26/05/2016 |
300 | N | approved | 27/05/2016 | Text1 | 27/05/2016 |
400 | N | approved | 10/10/2016 | Text1 | 10/10/2016 |
500 | N | Reject | 10/12/2016 | Text4 | 10/12/2016 |
500 | Y | Reject | 10/12/2016 | Text4 | 10/13/2016 |
three bar charts can be displayed on below 3 conditions
1)Where Status = approved
Fixed = 'N'
today date is greater than the Test_Date-60 (bar chart)
2)Where status = approved
Fixed = 'N'
today date is is greater than the Test_Date (bar chart)
3)Where Satus = Reject
Match where the role has Text4 (bar chart)
Could you please help on above three set expressions.
If this is a new requirement, I will urge you to close this thread by marking correct and helpful answers and create a new thread for this.