{ FIXED YEAR([Order Date]), [Customer ID]: COUNTD([Order ID]) } { FIXED [Customer ID]: MIN(YEAR([Order Date])) } RUNNING_SUM(COUNTD([Customer ID])) [Running Total]/ SUM({ FIXED [Customer Cohort]: COUNTD([Customer ID])})
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter