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?
Page 1 / 1
Hi 
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
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.