LCFS - Metabase - Calibrate "Available Compliance Unit Availability for Every Organization" Query
- Dominant language
- Python
- Stars
- 6
- Forks
- 6
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 87
Description
**Describe the task**
Investigate and calibrate the Metabase card for "Available Compliance Unit Availability for Every Organization." There appear to be transactions missing from this query that are present in the TFRS version of the same query.
**Purpose**
To ensure the Metabase query accurately reflects all relevant transactions and matches the data presented in the TFRS version. This will maintain consistency between systems and ensure reliable compliance reporting.
**Acceptance Criteria**
- [ ] Compare Metabase query output with TFRS query output for the same dataset
- [ ] Identify specific transactions missing from the Metabase results
- [ ] Determine the cause of the exclusion (e.g., join conditions, filters, date ranges)
- [ ] Update the Metabase query to include missing transactions
- [ ] Validate results against TFRS to ensure parity
**Additional context**
See the card attachment folder on Teams for details about specific missing transactions.
Cause of discrepancy is currently unknown.
Contributor guide
Assessment
This issue has not been assessed yet.