Go back to Mixpanel Go to Mixpanel
Question

Show Data UNIQUE in JQL Mixpanel

  • 7 August 2019
  • 1 reply
  • 193 views
O
Badge

Hi everyone,

I want to ask related How to get data Unique in JQL.

Reference Doc = https://developer.mixpanel.com/docs/jql-examples

.groupByUser(["Date_id"], mixpanel.reducer.null())
.groupBy([event => new Date(event.time),"properties.category_name"], mixpanel.reducer.count())

My Question when I run Query always show 1 row?

Kindly need help me sir


1 reply

F
Userlevel 1
Badge

Hey @ottoFikri, I am not exactly sure what your goal is... it sounds like you want more than one row to show up on your query. If you want to group by multiple properties, I have shared a query below that would show that. 

function main() {

  return Events({

    from_date: '2019-06-13',

    to_date:   '2019-08-12'

  })

  

  .groupBy(["properties.$region", "properties.mp_country_code"], mixpanel.reducer.count());

}


Hope this helps you out!


Reply


Check out the MP Learning Series

View webinar View webinar View webinar