Knowledge Library
Reusable "tribal knowledge" for this customer — code mappings, column meanings, metric/DAX templates, join rules and data-quality caveats. Each customer's library is private to them. Enabled entries are the ones the system is allowed to use when answering questions and building models.
You're viewing this library read-only. Only an admin can add or change entries.
CodeMapping
| Name | Description | Enabled |
|---|---|---|
| Fuel product codes | MasterItemId 1 = Jet A, 2 = Avgas 100LL, 3 = Diesel (DEF excluded). |
Yes |
DataQuality
| Name | Description | Enabled |
|---|---|---|
| Pre-2024 OrderDate gaps | OrderDate is null for some migrated 2023 rows — filter them out of trended reports. |
No |
Glossary
| Name | Description | Enabled |
|---|---|---|
| Net sales | Net sales = gross sales minus discounts and fuel tax; excludes intercompany transfers. |
Yes |
Join
| Name | Description | Enabled |
|---|---|---|
| Sales → Customer | Sales[CustomerId] joins Customer[CustomerId]; ~3% of rows are walk-in (CustomerId = 0). |
Yes |
Metric
| Name | Description | Enabled |
|---|---|---|
| Margin % | Gross margin as a percent of net sales. DIVIDE([Gross Margin], [Net Sales]) |
Yes |