# View: fact_sales_vendor_aggregated

**View Name:** fact_sales_vendor_aggregated
**Table Source:** `Derived from: Prod.Dim_Transactiontype, Prod.Workstation_Fact_Sales_Unified_Dbt, Royalty_Accounting, Royalty_Accounting.Prod`
**File Path:** `fact_sales_vendor_aggregated.view.lkml`

## Overview

- **File Size:** 2169 bytes
- **Lines of Code:** 73
- **Dimensions:** 4
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Comments & Notes

- this view is used to identify counts of labels within certain revenue/streaming thresholds
- i.e. Looker does not have the ability to identify all labels making over 1million in revenue
- this view allows this metric to be counted.

## Dimensions

| Name | Type |
|------|------|
| `labelid` | number |
| `sum_gross_rev` | number |
| `sum_streams` | number |
| `sum_net_rev` | number |

## Measures

| Name | Type |
|------|------|
| `count_labelid` | count_distinct |

## Filters

- `activity_date`
- `transactiontypeabbr`

## Derived Table

```sql
sql:
      select labelid
            , sum(gross) as sum_gross_rev
            , sum(sales) as sum_streams
            , sum(net_receipt) as sum_net_rev
      from royalty_accounting.prod.workstation_fact_sales_unified_dbt fs
      left join facts.prod.dim_transactiontype dt on dt.transactiontypeid=fs.transactiontypeid
      where {% condition activity_date %
```