📊

Interval Progression

Master Tag

Tips & Tricks

Created

Feb 8, 2021 12:31 AM

How It Works

https://www.redgregory.com/notion/2021/2/10/advanced-notion-formula-find-interval-progression

Usage

toNumber

replace

floor

Web Tags

Database

Formula

Alternatives

Cover

Donate

Red: capture interval between last two entries
Blue: capture percentage increase between the most recent interval and the previous — Red: capture interval between last two entries Blue: capture percentage increase between the most recent interval and the previous

Views Calculator

This Month Stats

Monthly Views

9000

12400

11900

18600

22600

26000

24500

40000

49300

64004

Last Interval


if(toNumber(replace(prop("Views"), ".*[,]", "")) - toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", "")) >= 0, "+" + format(toNumber(replace(prop("Views"), ".*[,]", "")) - toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", ""))) + " Views", format(toNumber(replace(prop("Views"), ".*[,]", "")) - toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", ""))) + " Views")

Increase %


floor(1000 * (toNumber(replace(prop("Views"), ".*[,]", "")) - toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", "")) - (toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", "")) - toNumber(replace(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ",(?:.(?!,))+$", ""), ".*[,]", "")))) / (toNumber(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ".*[,]", "")) - toNumber(replace(replace(replace(prop("Views"), ",(?:.(?!,))+$", ""), ",(?:.(?!,))+$", ""), ".*[,]", "")))) / 1000