9 Replies Latest reply on Jul 26, 2018 11:37 AM by Eva K

    count records when just one just one specific value is true

    Eva K

      First of all sorry for being vague in the question title. I have a dataset similar to shown below, I want to count Clients with the Status = 'Canceled' ONLY. So, when I show the count, I should only get one, which is Company = 'Kiwi'. 'Peach' has a canceled status for one order but it has orders with different statuses so I don't want to count it.

      I tried using a Set but it's not giving me the desired output.