Options
"Ordering dates for charting [SOLVED]"
Analyticaltim
Member Posts: 15 
Contributor II
Dear RapidMiner Community,
After much RapidMiner community board searching and internet scouring I turn to you for a simple question with undoubtedly a simple solution, albeit one I can't find for the life of me.
I am doing simple report based upon a concatenated attribute of Year and Month on the X axis and other KPI on the Y.
The issue is that data output is coming out in Advanced Charts as:
2003-01
2003-10
2003-11
2003-12
2003-02
2003-03
2003-04
2003-05
2003-06
2003-07
2003-08
2003-09
I need the output to come out in what I would call 'temporal' order. You know:
2003-01
2003-02
2003-03
etc.
I have tried inserting a 'Sort' function in the process before the concatenation step. I have also tried to 'Reorder Attributes' function as well with no luck. Thank you all for any help and insight you can lend on this process. 8)
All the best,
Tim
After much RapidMiner community board searching and internet scouring I turn to you for a simple question with undoubtedly a simple solution, albeit one I can't find for the life of me.
I am doing simple report based upon a concatenated attribute of Year and Month on the X axis and other KPI on the Y.
The issue is that data output is coming out in Advanced Charts as:
2003-01
2003-10
2003-11
2003-12
2003-02
2003-03
2003-04
2003-05
2003-06
2003-07
2003-08
2003-09
I need the output to come out in what I would call 'temporal' order. You know:
2003-01
2003-02
2003-03
etc.
I have tried inserting a 'Sort' function in the process before the concatenation step. I have also tried to 'Reorder Attributes' function as well with no luck. Thank you all for any help and insight you can lend on this process. 8)
All the best,
Tim
Tagged:
0
Answers
is your date attribute of the type "date"? If not, you can use a "Nominal to Date" operator to convert it, then it should be displayed in the correct order in the charts.
Regards,
Marco