2 Replies Latest reply on Apr 18, 2018 2:09 PM by Jonathan Drummey

    Summing distinct count of users for each step for each transaction id

    Jake Pecoraro

      I need to sum the distinct count of users for each transaction from the first to the penultimate step, and then add the non distinct count for the last step. For  example using transaction 67 i need to sum

      19 + 17 + 17 + 1 + 10 + 9 + 8 (all from distinct) + 6 (from non distinct) = 87. Not sure what the best way to go about this using calculated fields. I tried doing a custom query but i need it to be dynamic for when the date range changes. Thanks in advance!

      sample.PNG