Hi, I have a dataset with the fields customer and date. I can build a formula for distinct costumers and show for each month, but I’d like to make a formula to calculate the customers who have purchased at least once in the last 12 months, from the month I am showing, [example] I tried with run…

Hi @KLIKIN first convert the date string into a Date: [image] Then use windows function to get the partition you want by date: [image] where 11 stands for the previous 11 months, and 1 stands for the row month. Change it as you deem fit. This is the result: [image] I changed the field hea…

How can I make a formula that counts me in a 12 months rolling?

Q&A

KLIKIN November 23, 2023, 10:11am 7

No, I think this function is not for moving date ranges

Running Sum - Sum over 12 months but starting with daily-aggregated data

Topic		Replies	Views
Trailing 12 month rolling distinct count Q&A analysis , quick-sight , calculations	5	1363	April 27, 2023
Running sum of the last 12 months Q&A analysis , quick-sight , calculations	2	2145	March 9, 2022
Running Sum - Sum over 12 months but starting with daily-aggregated data Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	8	727	July 22, 2024
Trailing 12 month distinct counts for each month in the dataset Q&A analysis , quick-sight , calculations	1	340	April 19, 2023
Rolling 12 monhs calculation Q&A quick-sight , calculations	2	1329	September 26, 2022

How can I make a formula that counts me in a 12 months rolling?

Related topics