cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
seenai Frequent Visitor
Frequent Visitor

Custom Sorting not working

Hi,

 

In the below example I need to SORT the data based on date.

Visual : Maintenance Cost

X-Axis : Year & Month are text data.

RELATION : The Date fields in MAINTENANCE data and master table MONTH_YEAR are related.

 

Help me to sort the data.

 

Sort1.jpgSort2.jpg  

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson New Contributor
New Contributor

Re: Custom Sorting not working

@seenai - Go to the Model View, and set the following property for the Month:

Sort By Month Number.PNG

3 REPLIES 3
natelpeterson New Contributor
New Contributor

Re: Custom Sorting not working

@seenai - Go to the Model View, and set the following property for the Month:

Sort By Month Number.PNG

seenai Frequent Visitor
Frequent Visitor

Re: Custom Sorting not working

@natelpeterson 

Great!!

I have been searching for this solution from the today morning.

Thank you very much. Smiley Happy

Super User
Super User

Re: Custom Sorting not working

Hi,

Ideally the relationship should be from the Date column of Maintenance Cost and KPI MfgExp Table to the Date column of the Calendar Table.  From the Month column of both Tables, we should be able to create another column in each Table with proper dates.  The benefir of this approach will be that you will be use Date/Time Intelligence functions with ease.