Question

Show Data UNIQUE in JQL Mixpanel

  • 7 August 2019
  • 1 reply
  • 193 views

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

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