Can we order the elements in the dimension tables how we would like and not in alphabetical order? In a discover have it grouped?
Can the elements in the dimension tables how we like and not in alphabetical order? When you open the discover it's always in alphabetical order the elements. Is there a way not using folders to group say all the address items together in the order I prefer?
For example: street address line 1, street address line 2, City, State, Region, Zip code
2 replies
-
Hi , I placed a Feature Request for this some time ago: https://community.pyramidanalytics.com/t/h7ykbx5/allow-custom-order-for-all-objects-within-a-model
Maybe a few "thumbs up" from you and your colleagues/users could bring some fresh attention to this post... -
Hi
If your model is populated using a Model data flow, you could create a new virtual column in your table and assign a number to it based on the value in the column you want ordered, then sort the column on that virtual column.