Datasnips was built out of frustration in wasting time searching for Data Science & AI code snippets through old projects, documentation and internet sources.
We wanted a platform to easily find & organise our snippets, to share them with the community and discover those shared by other users.
At Datasnips you can quickly search, discover and bookmark snippets from the community, curate your own snippet library for easy reference and share your own snippets for others to use.
Our aim is for Datasnips to be the place where everyone can find the code snippet they need. Sign up to be part of the community.
SQL window function II: percent growth
***VERY IMPORTANT***
TAKE NOTE OF THE PARENTHESIS
TAKE NOT OF 0.0 TO MAKE SURE COMPUTATION IS IN FLOAT
select date_trunc('month', created_at)::date as date
, count(*) as count
, round(((100.0 / (lag(count(*)) over (order by date_trunc('month', created_at)::date asc))) * count(*)) -100, 1) || '%' as percent_growth
from posts
group by date
order by date ascBy changjulian17 - Last Updated Dec. 23, 2021, 12:51 p.m.
