# View: anr_shazam

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

## Overview

- **File Size:** 3683 bytes
- **Lines of Code:** 145
- **Dimensions:** 18
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `shazams` | number |
| `shazams_change` | number |
| `shazams_current_weekly_change` | number |
| `shazams_daily_change` | number |
| `shazams_growth` | number |
| `shazams_acceleration` | number |
| `average_shazams` | number |
| `shazamed_tracks` | number |
| `last_week_shazamed_tracks` | number |
| `shazamed_tracks_change` | number |
| `shazamed_tracks_growth` | number |
| `shazams_per_track` | string |
| `last_processing_date` | date |
| `artist` | string |
| `shazam_weekly_change_in_shazams` | number |
| `shazam_last_weekly_change_in_shazams` | number |
| `shazam_percentage_change_in_shazams` | number |

## Derived Table

```sql
sql: SELECT
          SH.ARTIST,
          SH.CURRENT_SHAZAMS AS "Shazams",
          SH.CURRENT_WEEKLY_CHANGE_IN_SHAZAMS AS "W. Shazams",
          SH.WEEKLY_CHANGE_IN_SHAZAMS AS "Last W. Shazams",
          SH.DAILY_CHANGE_IN_SHAZAMS AS "Daily Shazams",
          ROUND(100 * SH.PERCENTAGE_CHANGE_SHAZAMS, 2) AS "% Shazams Growth",
          ROUND(100 * SH.ACCELERATION_SHAZAMS, 2) AS "% Shazams Acceleration",
          SH.AVERAGE_SHAZAMS AS "Average Shazams",
          SH.CURRENT_TRACKS_COUNT AS "Shazamed Tracks",
          SH.LAST_WEEK_TRACKS_COUNT AS "Last Week Shazamed Tracks",
          SH.WEEKLY_CHANGE_IN_TRACKS_COUNT AS "Weekly New Shazamed Tracks",
          ROUND(100 * SH.PERCENTAGE_CHANGE_IN_TRACKS_COUNT, 2) AS "% New Shazamed Tracks Growth",
          SH.SHAZAMS_PER_TRACK AS "Shazams Per Track",
          SH.LAST_PROCESSING_DATE
          FROM
        TABLE({% parameter shazam_table_name %
```