Skip to main content
rachelhibbardtmo
Contributor ⭐️⭐️⭐️⭐️
July 14, 2021
New Idea

Horizon Analytics - Report Builder - Sort by more than 1 field

  • July 14, 2021
  • 2 replies
  • 92 views

So happy that Horizon Analytics now allows you to select which field you would like to sort on, the order and where to put nulls, HOWEVER would really love to be able to sort on MORE than 1 field. 

 

For example, we have a report that stores monthly data for each account. I had to pick between sorting on month (and getting accounts in random/different order for each month) or on account name (and getting months in random/different order for each account).

Ideally I could sort by multiple columns and indicate sort first by month desc, then sort by account name asc.

2 replies

sai_ram
Expert ⭐️⭐️
July 15, 2021

@rachelhibbardtmo thank you for sharing the request here, we should check the technical possibilities for sorting on multiple fields. I will let you know here.

Stuart
Helper ⭐️⭐️
February 6, 2024

Hey folks, adding my +1 to this and resurfacing this idea; the ability to sort by multiple fields (similar to functionality in excel) is pretty important for displaying more complex datasets with ordering that is logical to the end user.