# View: dt_new_signing_revenue_estimate_calculator

**View Name:** dt_new_signing_revenue_estimate_calculator
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `dt_new_signing_revenue_estimate_calculator.view.lkml`

## Overview

- **File Size:** 4001 bytes
- **Lines of Code:** 208
- **Dimensions:** 8
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `store_id` | number |
| `store_name` | string |
| `country_name` | string |
| `transactiontypedesc` | string |
| `ppr_usd` | number |
| `store_ratio` | number |
| `country_store_ratio` | number |
| `country_streams` | number |

## Measures

| Name | Type |
|------|------|
| `store_streams_transaction_type` | sum |
| `estimated_revenue_usd` | sum |

## Derived Table

```sql
sql:
      with user_inputs_country_pct_1 as ( select
    {% parameter country_1 %
```