Sort Page Selector on Dashboard

Highlighted

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. 

11 REPLIES 11
Highlighted
Certified Master Anaplanner

Re: Sort Page Selector on Dashboard

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

Highlighted

Re: Sort Page Selector on Dashboard

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.

Highlighted
Certified Master Anaplanner

Re: Sort Page Selector on Dashboard

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.

Highlighted

Re: Sort Page Selector on Dashboard

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

Highlighted
Certified Master Anaplanner

Re: Sort Page Selector on Dashboard

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

Highlighted
Super Contributor

Re: Sort Page Selector on Dashboard

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.
Highlighted
Master Anaplanner/Community Boss

Re: Sort Page Selector on Dashboard

@ChrisHeathcote 

 

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

Highlighted
Super Contributor

Re: Sort Page Selector on Dashboard

@rob_marshall 

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

 

Highlighted

Re: Sort Page Selector on Dashboard

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 ?