# View: country_ranks_for_bi_analytics

**View Name:** country_rank_bi_analytics_by_revenue_selected_months
**Table Source:** `Derived from: Bi.Analytics_Track_Level`
**File Path:** `country_ranks_for_bi_analytics.view.lkml`

## Overview

- **File Size:** 1850 bytes
- **Lines of Code:** 58
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 2

## Dimensions

| Name | Type |
|------|------|
| `country_code` | number |
| `country_total_units_for_selected_months` | number |
| `country_rank_for_selected_months` | number |

## Filters

- `rank_date_filter`
- `rank_isrc_filter`

## Derived Table

```sql
sql: select
        country_code
      , sum(units) as country_total_units_for_selected_months
      , rank() over (order by sum(units) desc) as country_rank_for_selected_months
      from bi.ANALYTICS_TRACK_LEVEL ACC
      where {% condition rank_date_filter %
```