Sort Page Selector on Dashboard

Hello Everyone,

Is there any way we can sort the page selector on dashboard in ascending/descending order having 3 levels of hierarchy in the both old and new UI/UX?

Example
I have a hierarchy as L1->L2->L3

So if i apply a sort it should be applied in all the three levels and reflect on page selector published on dashboard. 

Tagged:

Answers

  • Hello, 

    I was also curious to try it sort. Unfortunately I could not find a way in the new UX to actually sort it in the drop down selector.

    But as a workaround, you could publish a grid dimensioned by this hierarchy and will apply sorting, it could be used as a navigational grid - end user need just to click to a right product and this selection will be synchronised.

    In the dashboards I could not order it with all parent hierarchies, but it seems that you could sort a flat product list without hierarchy.

    Here are my steps:

    1) I have a sorting line item which is calculated via RANK function. I could adjust position by changing values in COUNT lineitem.

    Screenshot 2020-09-10 at 12.00.41.png

     

    2) I will do "reselect levels to show" to display only products L2 (P3 in your case)

    Screenshot 2020-09-10 at 12.01.20.png

     

     

     

    3) I changed Count value for product "Nougatacious" to change its position from 6th to1st.

    Screenshot 2020-09-10 at 12.01.45.png

     

     

    4) I pivoted dimension and saw that my sorting was saved.

    Screenshot 2020-09-10 at 12.02.04.png

     

     

     

    5) I played with other product values to re-order them dynamically and they were changing position in a drop-down page selector list.

     

    Hope my answer will help

  • Hi @nikolay_denisov ,

    I am afraid that I tried a similar approach but it didn't worked out. The sort order will preserve in the module but when you publish this as a page selector on the dashboard, the sort order doesn't preserves.

  • Hello Again

    I've tried to publish this on a dashboard - it is still working, but I have just a dimension of a products.

    It may happen that this would not work the same way with more dimensions in a module.

    Screenshot 2020-09-11 at 14.21.58.png

     

    But from a UX design perspective I would still rather go ahead with "Navigation Grid" that allowed you to rank products more flexibly and simple in maintaining as well applicable both for UX/Dashboards.

  • Hi @nikolay_denisov ,

    You are correct the sort order will be preserved when it is published as a page selector in a module, but when we publish the list as a page selector for the dashboard, the sort order is not preserved. That's what the ask whether we can sort it or not

  • Ok, Got it. 

    I confirm, publishing a list selector - basically you cannot do anything with it.

    Again, as a workaround you could publish a module with a page selector and hide all columns and make a first row very small like 5pxs. So it will looks like page selector.

    Regards, Nikolay

  • As others have confirmed it is not possible to dynamically change the order of items in a list.
    My suggestion is to change the list order manually or reimport the list already sorted.
    When new items are add make sure to add them into the list at the required oder.
  • @ChrisAHeathcote 

     

    I have been waiting until this weekend, but please take a look at the Sort feature released this weekend:

     

    https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html

     

    Rob

  • @rob_marshall 

    Nice! I like it. It will come in very handy I am sure for many different uses.

     

  • Hi @rob_marshall ,

     

    I tried using the order list action but it is not working for me. 
    I have a composite list to sort having the hierarchy P1->P2->P3.
     

    I am sorting the P3 list(a numbered list) using the sort criteria as the the display name for this list. So whenever I am running this order list action, nothing is happening. The order remains the same.

    Can you please help me with this.

     

    Also will this sort the list published as Page Selector too on Dashboard ?
      

  • @CommunityMember118291 

     

    Can you post some pictures so we can see what is going on?

  • Hi @rob_marshall ,

    Figured it out, have to sort all the lists in the hierarchy(P1,P2,P3 in my case) to get the lowest level sorted in the desired order (ascending/descending).

    Thanks for letting us know about this newly added feauture. 🙂