Enhance the DataView Layout SORT function

Mike Westley

Currently DataView layouts can only sort by ONE block/entity.   

 

It would be helpful to be able to apply a sort using several blocks.   For example, where a client's data has 3 levels - eg Site, Floor, and Work Area and you wish the report to sort by Site, then Floor then Work Area descriptions, and the date the Work Area was occupied - it would be helpful if DataViews could be created that are sorted by multiple entities, not each just one.  In isolation, a column can be clicked on, but that does not provide the answer required.

 

 

A workaround, is to create a reporting cube (Text) made up of the concatenation of the entities required to be sorted by - for example, the following 4 records "SiteAFloorVArea320170730", "SiteAFloorVArea420170730", and "SiteAFloorVArea420170615", and "SiteAFloorVArea320170805" would be listed in this order:

 

"SiteAFloorVArea320170730"

"SiteAFloorVArea320170805"

"SiteAFloorVArea420170615"

"SiteAFloorVArea420170730"

 

The Text cube would be created , made up of Site Name & Floor Name & Work Area Name & Occupied Date (date would be in format YYYYMMDD).

 

Cheers

Mike

Monisha Jain

Thank you for sharing your idea, Mike. We understand the need of this solution.

This idea is part of our development roadmap and we aim to release this feature by first half of 2024 as part of the new toolbox. We encourage you to continue submitting your ideas and suggestions in the future, as we are always open to hearing new perspectives and feedback. 

Giles Corner

This can be done by creating an algorithm that concatenates the required fields, there's no need to create a dedicated cube.