SimonHowell

Sorting by another column

Recommended Posts

Hi, I have a list that collects a large amount of data including a date of event.

 

From this, calculated columns convert the date field into

  1. A "Financial Year" month NUMBER where April = 1
  2. A TEXT month such as April
  3. A "Group by Month" column that combines the above so that a "grouped" view is sorted in the correct order (1 - April, 2 - May...)

Unfortunately options 2 and 3 are text fields and get sorted as such (1 - April, 10 - January, 11 - February, 12 - March, 2 - May...).

 

Is it possible to group a chart by the Displayed Month (Option 2) but sort it by Financial Year month NUMBER (1, 2, 3 ...)?

 

Thanks

 

Simon

Share this post


Link to post
Share on other sites

Hi

 

From Collabion Charts Version 2.0 we have added a new functionality which enables you to sort x axis of a chart based on some other column than the actual x axis column. 

 

For more details please visit Collabion documentation for 'Series Customization

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now