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 🙌🏻 🙌🏻
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
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…
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
