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