Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Bounce rate, page exit rate, time difference between first and next page(different from 1st page)

Hi All,

I'm new to powebi. Can someone help me to calculate bounce rate, exit rate and time difference between first and last visited page. 

I have added rank based on userid.  Please refere attached screenshot for sample data.

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    It is recommended that you use DAX to calculate.

    Can you provide some of your specific expected results?

    Based on the sample data you give, what the expected result is.

    To calculate the time difference, we often use DATEDIFF function.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

      I want to calculate bounce rate= (Sessions where users leaving page in <=1min)/Total sessions. I'm expecting below results. where first and next page should not be the same.

      UserFirst_PageFirst_DateTimeSeq_No1Next_PageNext_DateTimeSeq_No2Diff(Min)
      1a2/08/2022 17:491b2/08/2022 17:4920
      2a28/07/2022 19:011b28/07/2022 19:0120
      2b28/07/2022 19:012a28/07/2022 19:0332
      2a28/07/2022 19:033b28/07/2022 19:1249
      2b28/07/2022 19:346a28/07/2022 19:46712