3 Replies Latest reply on May 30, 2016 2:11 PM by Manjula Raj

    How to calculate the number of correct answer of a user in the segment of 50

    Manjula Raj

      I've table history where it has the id, user_id,chart_id and is_correct and other columns. I want to calculate the no of correct_answers of user in the first 50 charts, then from 50 to 100 charts how many corrects answers and same for 150 to 200.


      I want something like this:


      If WINDOW_MIN( index() >50 and < 1001) then SUM(IF [Is Correct]=TRUE then 1 END)


      Please help me.