Avg views

[sepiariver]

COUNT(*) / DATEDIFF(MAX(CAST(datetime AS CHAR)), MIN(CAST(datetime AS CHAR))) AS views_daily