Sorting / Ordinal for dimension status attribute

View previous topic View next topic Go down

Sorting / Ordinal for dimension status attribute

Post  ryno1234 on Tue Oct 06, 2015 4:23 pm

I have a dimension (vehicles) which carries a Status attribute. The various values that can exist in a status have a somewhat nature flow to their order (i.e. New, In Service, Sold). When displaying data grouped by this status value, I'd like to order my groupings by this natural flow. What is the best way to represent an ordinal for a given dimension value?
avatar
ryno1234

Posts : 33
Join date : 2015-01-07

View user profile

Back to top Go down

Re: Sorting / Ordinal for dimension status attribute

Post  ngalemmo on Tue Oct 06, 2015 6:05 pm

You could add a report sequence attribute to the dimension.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Sorting / Ordinal for dimension status attribute

Post  ryno1234 on Tue Oct 06, 2015 7:17 pm

Thanks, I had figured it might be as simple as adding new attribute, but I didn't know if a different method was more accepted.

Thank you again.
avatar
ryno1234

Posts : 33
Join date : 2015-01-07

View user profile

Back to top Go down

Re: Sorting / Ordinal for dimension status attribute

Post  zoom on Wed Oct 07, 2015 2:07 pm

Would like to give a tip on creating a sequence and its data type. It is more flexible to use a decimal sequence data type then use a integer data type. For example if you already have a sequence number 1, 2, 3 and latter down the road business user wants to see "rebuilt" between "new" and "In Service" value, then giving a sequence value of 1.5 would prevent any re-sequencing if you used decimal data type.

seq#, value
1 , New
1.5 , Rebuilt
2, In Service
3, Sold

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Sorting / Ordinal for dimension status attribute

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum