The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Advanced charts -display domain axis values in custom order

kcallankcallan Member Posts: 4 Learner III
edited May 2020 in Help

I have set up a bar chart which displays values grouped by finacial year quarter, a nominal attribute. The data is displayed with the x-axis labels in alphabetical order rather than cronological order as they appear in the data, ie Q1 2012, Q1 2013, Q2 2012, Q2 2013 etc, as shown below. I need them to be ordered by year and quarter, such as Q1 2012, Q2 2012, Q1 2013, Q2 2013.

Capture.PNGCurrent ordering of x-axis labels

Tagged:

Best Answer

  • yyhuangyyhuang Administrator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 RM Data Scientist
    Solution Accepted

    Hi @kcallan,

     

    Unfortunately we do not have the customized order for nominal attributes in advanced charts for now. In charts, RapidMiner maps the first string of the nominal attributes to "0", the second one to "1" etc. To control the ordering of the mapping is by ordering your input data ("sort" operator). If you are using the new "adavanced charts" instead of the "plot view", nominal values are always sorted alphabetically.

     

    Here is a workaround for you. You may change the quarter-year values to year-quarter values by "Generate Attributes" to create a new column like

    2012Q1, 2012Q2, ..., 2013Q1,..., 2013Q4, ...

     

    HTH!

     

    YY

Answers

  • kcallankcallan Member Posts: 4 Learner III

    Thanks - I will use the workaround you suggest.

Sign In or Register to comment.