I would like to get the list of events based on a user custom field named "Company ID". How do I write this JQL query?
I tried this but didn't work:
function main() {
return Events({
from_date: '2019-05-08',
to_date: '2019-05-30',
})
People(),
{
type:"inner",
selectors:[{selector:
'properties["company_id"] == "0cd2eaf.....df1326ca"'}]
}
}
hey
Thanks for the link.
However, I tried that query:
function main() {
return Events({
from_date: '2019-05-01',
to_date: '2019-05-31',
event_selectors: [
{selector: '"0cd2eaf.....df1326ca" in properties["company_id"]'},
]
})
}
But that returns only the company id from events (there are only a few only, not all rows have this field in the list of events).
What I need is the company id from the user table:
So, the list of event from company id in users.
Thank you for your help.
@Willyv, I tried with join as well. But I don't have the details of the events:
function main() {
return join(
Events({
from_date: '2019-05-01',
to_date: '2019-06-03',
}),
People(),
{
type:"right",
selectors:[{selector:
'properties["company_id"] == "0cd2eaf.....df1326ca"'}]
}
);
}
In the result, I supposed it it is in the event.dataset...
Can you help?
Hey
function main() {
return join(Events({
from_date: '2019-06-17',
to_date: '2019-06-18',
}),
People({
user_selectors: [{selector: 'user["user_prop"] == "foo_bar"'}]
}),
{type: 'inner'}
)
.groupBy(["event.name"], mixpanel.reducer.count());
}
This assumes queries like:
var main = () => People().reduce(mixpanel.reducer.any())
returns objects like:
{"properties": {"user_prop": "foo_bar"}, "distinct_id": "bar", ...}HTH,
-Marcus
how can i get all event for each user, means user and his all events in one object
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.