For example i got a “start event” with an event property of “count”. I want to sum up the “count” property for users where no “end event” has happened yet.
Thanks for the help!
Solved
Sum up an event property for “start events” without an “end event”
Best answer by Saish Redkar
Hey
Here’s a sample chart which tries to replicate your use case -
https://analytics.amplitude.com/demo/chart/new/ony38k9
This gives the daily property sum on the event charted for last 30 days for users who didn’t perform a certain event. Switching to the bar chart view will aggregate the sum over the time frame if needed.
Let me know if I have the correct interpretation of your use case. Hope this helps.
+10Hey
Here’s a sample chart which tries to replicate your use case -
https://analytics.amplitude.com/demo/chart/new/ony38k9
This gives the daily property sum on the event charted for last 30 days for users who didn’t perform a certain event. Switching to the bar chart view will aggregate the sum over the time frame if needed.
Let me know if I have the correct interpretation of your use case. Hope this helps.
Thank you for your help Saish!
It helps me a little bit, we have following use case: people come online and go offline the come online event contains an events property which we need to sum up.
+8Hi
I would agree with Saish that this would be the best option for you. The sum of the property value “count” on that event. Does it not suit? If so, why not? Thank you!
Kind Regards,
Denis
+10Hi
Can you elaborate a bit more on the use case if the property sum approach isn’t working?
Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
1 person likes this
Hello Guys,
basically we not only have one positive one negative event so to speak. We have a number of positive and a number of negative events. And if the positie events are one more then the sum should be made.
KInd regards,
Alex
+8Sorry
Hello Denis, we currently have not yet implemented it.
The use case is as follows: We have streams that come online and go offline. When a stream is coming online we have the viewer count as event property.
Now we wanna have the sum of viewers of all streams that are currently online.
+8Hi
I think for that case it would be best looking at a smaller granularity such as hour but since it is an events-based platform, it would be difficult to report on real-time usage analytics. You could look at the viewer event and then group by the viewing channel name, and then do prop sum. This would give the current viewers for each channel in the last day or hour, perhaps. You can also look at just today, Last 0 days, and do a sum of all online event viewers. Would either of those solutions work?
Kind Regards,
Denis
1 person likes this
+10Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
1 person likes this
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.