Hi All,
I have a below set of data.
Contract Name | Contract Type | Effective Date | Expiration Date |
Contract1 | Amendment | 2017-12-10 | 2021-12-10 |
Contract2 | Other | 2016-12-20 | 2021-12-19 |
Contract3 | Amendment | 2016-07-28 | 2021-07-27 |
Contract4 | Order | 2016-11-09 | 2021-10-30 |
Contract5 | Maintenance | 2016-09-20 | 2021-09-15 |
Contract6 | Other | 2016-08-31 | 2021-07-30 |
Contract7 | Amendment | 2020-07-31 | 2021-07-30 |
Contract8 | Order | 2018-11-30 | 2021-11-29 |
Contract9 | Maintenance | 2018-11-30 | 2021-11-29 |
Contract10 | Other | 2019-12-15 | 2021-12-14 |
Is it possible to create a view as below.
Should have contract name & type dimensions. Then Effective and Expiration date should shown in Bar with today as reference line and # no of days remaining to expire
reference screenshot.