1 2 Previous Next 20 Replies Latest reply on Sep 20, 2018 2:01 PM by Gerardo Varela

    Count of user who were first.

    Carrie Atwood

      I have a group of users who are engaging in conversations and I want to create a report that shows how many of the conversations are started by the student vs the teacher.  The challenge I am running into is that there are multiple messages, each with a sequence of 0 through 4, but what we are considering a conversation doesn't start at 0, and it doesn't always start at 1 or even 2.  I have a calculated field that determines if a conversation has started but am not successful at designating which user was the one to start the conversaion. I have attached a workbook with sample data, but this image shows that my end goal is to show that Students started 2 conversations and Teachers started 1.

        1 2 Previous Next