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!
Hey alex.s
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.
Hi alex.s ,
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
Hi alex.s Can you elaborate a bit more on the use case if the property sum approach isn’t working?
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
Sorry alex.s , I am stil not entirely sure what you mean. Can you show me some charts to illustrate what you mean? What events exactly? How would you like the sum of the property to behave versus how it is right now?
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.
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?
Hey Denis,thank you, that should do the job Kind Regards,Alex
Denis Holmes 🙌🏻 🙌🏻
Hi everyone, We're using Amplitude's S3 export and noticed that for every export batch, two files are created in our bucket: 1. A `_complete` file (0 bytes, seems to be a flag/marker) 2. A `.json.gz` file (the actual event data) The actual data lives entirely in the `.json.gz` file, so the `_complete` file doesn't seem to…
Hello, We have a blank screen after adding in Amplitude/Session replay into our app, it seems like some windows appear for a breif second before dissapearing back to the black screen. Currently are app is NOT using Jetpack compose. This is on a samsung active 3,
Hi, I set integration between Amplitude and Appsflyer(V1) - I see that integration is active but when I'm trying to check this integration in Amplitude section “Connect AppsFlyer” on the second step I see “Listening..” and nothing happend. Does this second step show any activity only if I begin sending events from…
I want to be able to identify and track the users that are hitting a specific page (feature) that is limited by our product tiering in our multi-tenant SaaS app. Our customer businesses have their own segmented dashboard based on the subdomain of the app url (somebusiness.ourapp.com), and I have figured out how to capture…
Hi there, I'm trying to integrate the surveys for react native feature to our app. I've followed the guide and I verify the plugin is "booted" correctly (right user id and device id) but when opening a link, while the linking handlers are correctly triggered, the call to handleURL is returning false - I've verified the url…
