Using Aggregations on Parameterized Snippets calling SQL Views
I love Jan's post on how to use filters/snippets/views as parameters in a snippet (read about it here!) Here, he utilizes double bracket notation to properly reference his view in the SQL snippet.
I just had a case where a customer wanted to leverage this approach, but also wished to aggregate the results in their view. To do this, we'd use an alias to make our bracket notation more manageable:
select [alias.column_name:aggregation] from [[view_name] as alias]
Happy Periscoping :)