bcgov / bcgov/lcfs

LCFS - Metabase - Calibrate "Available Compliance Unit Availability for Every Organization" Query

Open
#3,140 1 comment 0 reactions 1 assignee Claimed by @AlexZorkin View on GitHub
Medium Metabase - Power BI Task
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.