Solved

Get the Max Value of a property for each user

  • 6 April 2022
  • 1 reply
  • 169 views

Badge

I have an event that fires each time a user visits my page that indicates their progress on a specific set of tasks (ie have they completed 1 task, 2 tasks, etc). This has created some problems for me since I am dealing with a duplicate data issue.

I want to create a bar chart where the x axis would be the number of tasks completed, and y axis the number of users who completed that number of tasks, but I would like each user to only appear once, whatever their max number of tasks is (as this is actually the number of tasks the user has completed). Is this something I can do with the formula option?

icon

Best answer by belinda.chiu 7 April 2022, 18:10

View original

1 reply

Userlevel 6
Badge +8

Hi @reandrews ! Welcome to the Amplitude Community! 👋

It sounds like perhaps the following two posts below would help with what you’re looking for. I also recommend following up on these posts if you have additional questions or what to share your findings! 

 

 

Reply