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 🙌🏻 🙌🏻
Hey there I've been playing around for a couple of hours with the guide and analytics which fires properly on the UI but wouldn't give me any analytics. I read that there is another script that should be installed for the analytics part of things. Would anyone be able to guide me towards the potential script or some…
All my data is being collected through Firebase I want to export all this data in Amplitude and keep it synced with GA4, I tried adding data sources as BigQuery and GA4 both but for some reason it only partially imported the data and now its not working, I cant even see connected sources. Any help will be appreciated.
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
