2 Replies Latest reply on Jun 7, 2017 4:53 AM by Akhilesh Singh

    Filtering sum of specific value

    Iiro Estola

      I have data source with different steps in a flow for different dates, and their counts let's say:

       

      1 xxx 500
      2 yyy 200
      3 ddd 100
      NA test 50
      NA test2 600
      NA test3 400

       

      I'd like to visualize counts, but if the value is NA to filter based on amount. I already tried this IF [step_number] == "NA" THEN [step_count] END

       

      But dragging this to filter actually filters everything. My goal is to only filter if the step_number is "NA". Any advice? To clarify, filtering by 500 with this calculated field would show step_numbers 1,2,3 and NA-test2