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.

Accepted answers

All comments

nikolay_denisov

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

CommunityMember118291

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.

nikolay_denisov

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.

CommunityMember118291

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

nikolay_denisov

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

ChrisAHeathcote

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.

rob_marshall

@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

ChrisAHeathcote

@rob_marshall

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

CommunityMember118291

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 ?

rob_marshall

@CommunityMember118291

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

CommunityMember118291

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. 🙂

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385