4 Replies Latest reply on Mar 8, 2017 2:20 PM by Sherzodbek Ibragimov

    Custom Order Sorting Based on the Values in A Dimension

    Josh Delekta

      Hello,

       

      Please see attached. I need helping creating a solution for custom sorting. In the visualization I have "Approver" and how many items they have in review based on the "Business Unit" the item is associated with. I'm familiar with the typical methods of sorting but I don't know how to define the order of approvers based on which business unit they are in. For example:

       

      BU 1, Sort Order

       

      Approver B

      Approver C

      Approver A

      Approver D

       

      BU 2, Sort Order

       

      Approver D

      Approver E

      Approver B

      Approver C

      Approver A

       

      BU 3, Sort Order

       

      Approver C

      Approver E

      Approver D

       

      The idea behind this is that it represents their spot in the approver chain. Approver A isn't necessary the first approver for BU 1, BU 2 or BU 3. The approvers change based on their BU. Is there any way to do this? Thank you!