I am trying to filter users in a retention chart based on their earnings greater than a certain dollar amount over the past 1.5 years.

Hi, I am trying to filter users in a retention chart based on their earnings greater than a certain dollar amount over the past 1.5 years. However, I can only go till the last 365 days. It says in the Amplitude tutorial that I can filter based on the past 36 months if I used monthly data. I am using monthly chart but I don’t see an option to filter based on months. I tried using cohorts but I still cannot go past 365 days. How can I accomplish this?

Find more posts tagged with

Retention

Accepted answers

All comments

liuaud

Hi Deepesh,

Thank you for writing in! My name is Audrey, and I am your Technical Support Agent here to help you.

Would you mind sharing your retention chart so that I can take a look?

Best,
Audrey

P.S. Checkout upcoming events and user meetups on our events page.

Deepesh

Hi Liuaud,

I used “Since” and found that I can go past 1.5 years. So no problem there. However, I am stuck trying to form a cohort who performed an event for the first time. Although I can accomplish this in the charts such as Retention or Segmentation, I cannot do the same while forming a cohort.

For example, I specify the users who performed an event and in my case “Subscription charged” and state a condition and when I try to filter only those who performed it for the first time, I cannot find the “historical count” filter.

Deepesh

I just figured out I can replace count with Historical count to filter the first time users. No worries. Thank you.

liuaud

Hi Deepesh,

That's great to hear! I will go ahead and close out the ticket, but please feel free to open this up again if you have any followup questions on this topic. Thank you, and have a great day!

Best,
Audrey

P.S. Checkout upcoming events and user meetups on our events page.

Quick Links

Unanswered Questions

playing videos 9:16 (vertical) in an iOS guide?
Hi all, We are getting set up on Amplitude and want to be able to have demo videos automatically show up in a guide in a 9:16 ratio (vertical/portrait) and not in the crunched landscape orientation that the current frame delivers for Vimeo and YouTube. We are using the iOS SDK, which seems like it may be the limiting…
Trying to import new user attribute from CSV but it doesn't work
I have a csv with 2 columns user_id and lead_source. I went to Catalog and selected CSV under Lookup Tables. Step 1: I brought in the CSV and Step 2: I mapped the first column (user_id) to User ID (Amplitude User). It showed me a sample of my CSV and showed both columns at the bottom of Step 2. I clickd Finish. I went to…
How to filter by Event properties in Segmentation chart
I am unable to find my Event Properties in the list of “+ Filters” in Segmentation chart.
notifications.integration.saveFailure - Unable to add Facebook Cohort as a Destination
Myself and other team members have tried using the Facebook Cohorts integration however we always receive the same error ‘notifications.integration.saveFailure When looking in Meta Business Manager it says that the integration is active however when going into the Destinations tab in Amplitude, it is blank I have tried the…
User ID is converting to a big number
I am setting user property wallet address, and using the same variable to set user ID. However, while walletAddress works (0xA66...54), User ID seemingly converts the hex to a big number (1.2905460614871781E+48) which is preventing us from using filtering and views. Any ideas?