1 Reply Latest reply on Nov 23, 2018 5:11 PM by Paul Wachtler

    How to manage different states

    Felipe Villena

      Hi guys,


      I have the following problem and i can't seem to find a working solution.


      I have ID's that can have 4 different states, lets say, A , B, C and D.  (this clasification is working)


      An ID can be in state B or C or D (that is working) but for state A, it must be in state A and at least one of B, C or D, depending on the condition for different states, but can't be in state A alone.


      Any ideas? I tried different IF and CASE expressions but can't make it work.


      Thanks in advance

        • 1. Re: How to manage different states
          Paul Wachtler

          Hi Felipe,


          What do you want your end result to look like?  Do you just want a count of the number of IDs in each stage?  If that's what you're looking to do then you can do something like this:


          {fixed [state]: countd([id])}


          That will count the number of distinct IDs for each state.  If you're looking to do something else, let me know.