9 Replies Latest reply on Aug 23, 2016 6:01 PM by Andrew Watson

    Is it possible to create a classification (dimension) based on a measure?

    Josh David

      In short - I want to create a dimension that is ClientStatus with three options: "New Client", "Reoccurring Client", & "Lost Client."

       

      I have a Year and Revenue field that I would like to classify each client by.  Essentially in pseudo code...

       

      If Client's revenue = 0 in 2015 and revenue > 0 in 2016 THEN "New Client"

      Else If Client's revenue > 0 in 2015 AND 2016 THEN "Reoccurring Client"

      ELSE IF Client revenue > 2015 AND revenue = 0 in 2016 then "Lost Client"

       

      However no matter how I write this calculation I cannot for the life of me get it to work.  I want to be able to use this dimension in a bunch of visuals to filter on only new clients or clients we lost to identify trends.

       

      Any advice on how to proceed with this?

       

      Thank you!!