Forum Discussion

JonSwed's avatar
JonSwed
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Need help grouping visitorId by session count and date

Hi all, So I'm importing Google Analytics data and have created a new table (from another table) where I'm counting sessions by user. This is the DAX I used to create my table: Table = SUMMARIZ...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi JonSwed ,

     

    I don't think you need a new table to create groupings in SESSION column. You can create a new column and use it for visualisation in your report.

     

    sessionGrouping = IF([session] >= 1 && [session] <= 5, "1-5 Group",

                                       IF([session] >= 6 && [session] <= 10, "6-10 Group", "Above 10 Group"))

     

    See the above example for column creation.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi JonSwed ,

 

I don't think you need a new table to create groupings in SESSION column. You can create a new column and use it for visualisation in your report.

 

sessionGrouping = IF([session] >= 1 && [session] <= 5, "1-5 Group",

                                   IF([session] >= 6 && [session] <= 10, "6-10 Group", "Above 10 Group"))

 

See the above example for column creation.

 

Thanks,

Pragati

JonSwed's avatar
JonSwed
Icon for Advocate II rankAdvocate II
5 years ago

I spoke too soon - this seems to be working. Many thanks.