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.

Hi @alex.s ,

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

Hey Denis,

thank you, that should do the job :)

Kind Regards,
Alex

@Denis Holmes