7 Replies Latest reply on Jul 19, 2018 12:46 PM by Shinichiro Murakami

    How to plot the number of online attendee in Tableau?

    James Yan

      I have following data source for a webinar:

        

      customerStart timeEnd time
      100016/19/2018 14:006/19/2018 14:05
      100026/19/2018 14:006/19/2018 14:47
      100036/19/2018 14:006/19/2018 15:00
      100046/19/2018 14:006/19/2018 15:00
      100056/19/2018 14:006/19/2018 14:15
      100016/19/2018 14:076/19/2018 14:10
      100026/19/2018 14:496/19/2018 15:00
      100056/19/2018 14:156/19/2018 14:50
      100016/19/2018 14:306/19/2018 15:00
      100056/19/2018 14:516/19/2018 15:00

      During the webinar, I can observe that some audience can drop off and join back.

      I want to plot a line chart showing the number of audiences for each 5 mins.

      Similar like the chart I found online below:

      Seems I need to count distinct customer for each 5 mins time range.

       

      Can someone direct me how should I start?

       

      Thank you,

      James