"Ordering dates for charting [SOLVED]"

AnalyticaltimAnalyticaltim Member Posts: 15 Contributor II
edited June 2019 in Help
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

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,991 RM Engineering
    Hi,

    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
  • AnalyticaltimAnalyticaltim Member Posts: 15 Contributor II
    Thank you! That works like a charm.
Sign In or Register to comment.