On our application, we have trades (vehicles) and users bids on those vehicles.
We have an event called “place bid” and also a property to represent trades (trade_id).
All I want to do is to find out whats the avg # of bids per trade.
How should I do it?
I can easily find avg of any activity per user or per timeframe. But when it comes to per trade, I never succeed and then I have to fetch the data from other analytics tool such as snowflake in my case.
Is there a way/>