Querying User Actions: Identifying Multiple Actions in One Day | Mixpanel Community

Querying User Actions: Identifying Multiple Actions in One Day

How can I check the users who have done a particular action multiple times in a single day ? Its bit tricky to put that condition of 'multiple times' within a 'single day' . can you help ?

26 comments

Andrew S.
·
·
Have you tried this:
Andrew S.
·
·
Andrew S.
·
·
if you take out the breakdown, you can see all users on a particular date who rated >1x on any given day
Andrew S.
·
·
And if you change it to bars, you can do stacked breakdowns to see more groupings of the users, like
Andrew S.
·
·
Andrew S.
·
·
and maybe, if you are going to look at bars, you need to stack filters up top.
Andrew S.
·
·
so frequency of rated products > 1 AND distinct count of days = 1. So that would be users who rated > 1x on a single day.
Nadeesha E.
·
·
this is helpful and thanks so much for the quick feed back
Nadeesha E.
·
·
Andrew S. I always appreciate you detailed elaboration on the solutions. I have a small follow up question. Im trying to get this 'time' attribute for the aggregate property per user metric and im unable to get it from my data.
Nadeesha E.
·
·
My metrics looks like this , similar to yours. when I go through 'select event' under aggregate Property per user ,
Nadeesha E.
·
·
im not given the choice to select an event property , and it is given only the event labels only.
Nadeesha E.
·
·
how did u select time(day ) there ?
Andrew S.
·
·
In your lexicon, do you see, under Event Properties, $time?
Andrew S.
·
·
Time is an Event Property, not an event itself. So you select your event (like in my case it is Rate a Product) and then aggregate the property or breakdown on the property, being the Time property on the event.
Nadeesha E.
·
·
yes , I can see that under event property
Andrew S.
·
·
Ok, great. So I think the issue in your image is that you are selecting an event and not an event property
Andrew S.
·
·
I think in your image you need to select your same event (principal action vs) and then select the Time property on that event. in my example, I did the Rate a Product event and then selected the Time property on the event.
Nadeesha E.
·
·
I think the issue happens after I select an event (principal actions). When I try to pick the same event for 'frequency per user' and then choose 'Time' as the event property under 'Aggregate Property per User,' the pop-up only lets me select an event name, not an event property. I've attached a screenshot. How did you manage to select an event property there? It doesn’t seem to be an option for me.
Andrew S.
·
·
reselect the principal action v2 at that step and then the time property
Nadeesha E.
·
·
let me try
Andrew S.
·
·
https://www.loom.com/share/fe3d41e3ff1843598bb658adc7f3f788?from_recorder=1&focus_title=1
Nadeesha E.
·
·
it works , My respect for you for listening to me.thanks so much
Nadeesha E.
·
·
This is very valuable piece
Andrew S.
·
·
🙂
Andrew S.
·
·
Glad to help
Andrew S.
·
·
fwiw, the reason they make you do that step again is bc it allows you to be modeling one metric while selecting the aggregate property tied to a different event property. It is a bit confusing but once you have done it, it becomes more natural.
🙌1