42 lines
838 B
Markdown
42 lines
838 B
Markdown
|
|
|
|
## Upcoming Expiration
|
|
```dataview
|
|
TABLE
|
|
vendor AS "Vendor",
|
|
annual_cost AS "Annual Cost",
|
|
currency AS "Currency",
|
|
contract_end AS "Ends",
|
|
renewal_status AS "Renewal"
|
|
FROM "20 Work/Contracts"
|
|
WHERE status = "active"
|
|
AND contract_end >= date(today)
|
|
AND contract_end <= date(today) + dur(120 days)
|
|
SORT contract_end ASC
|
|
```
|
|
|
|
|
|
## Contract with notice deadline
|
|
```dataview
|
|
TABLE
|
|
vendor AS "Vendor",
|
|
notice_deadline AS "Notice Deadline",
|
|
contract_end AS "Contract End",
|
|
annual_cost AS "Annual Cost",
|
|
currency AS "Currency"
|
|
FROM "20 Work/Contracts"
|
|
WHERE status = "active"
|
|
AND notice_deadline
|
|
SORT notice_deadline ASC
|
|
```
|
|
|
|
|
|
## Portfolio by currency
|
|
```dataview
|
|
TABLE WITHOUT ID
|
|
currency AS "Currency",
|
|
sum(rows.annual_cost) AS "Annual Commitments"
|
|
FROM "20 Work/Contracts"
|
|
WHERE status = "active"
|
|
GROUP BY currency
|
|
``` |