# View: store_ranks_for_bi_analytics

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

## Overview

- **File Size:** 1307 bytes
- **Lines of Code:** 49
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `store_id` | number |
| `store_total_units_for_selected_months` | number |
| `store_rank_for_selected_months` | number |

## Filters

- `rank_date_filter`

## Derived Table

```sql
sql: select
        storeid
      , sum(units) as store_total_units_for_selected_months
      , rank() over (order by sum(units) desc) as store_rank_for_selected_months
      from BI.ANALYTICS_TRACK_LEVEL ACC
      where {% condition rank_date_filter %
```