Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
2 X-axis and 2 Y-axis plot.
Process_Intern
Member Posts: 13 
Learner II
in Help
Hi all,
I was wondering if somebody would know if it is possible to do a plot with 2 X-axis and 2-Y-axis plot. The goal of that is to compare a filtered set of data with the original. In Y, I have the level of a tank and in X the date. As an example, I would say that I am filtering my level to be above 4000 liters and if the level is under 4000 liters, take the data out. After the filter, I have a set of data that the date are not all there, some have been filtered some my 2 sets of date are not identical anymore. Now, I want to compare the resulting curves between my original datas and my filtered ones. I was wondering if somebody knew how to do that in RM.
If it is impossible, I know it is not the same compagny so maybe my post will get deleted but I am asking, does anybody know a way to do it in Excel. RM is my first solution, but my second would be to write an Excel with my datas and do my plots in Excel if it is working.
Note: I know how to have multiples Y-axis in RM and a secondary axis in Excel, but I would like to have 2 X-axis to compare my curves in RM.
Thanks
I was wondering if somebody would know if it is possible to do a plot with 2 X-axis and 2-Y-axis plot. The goal of that is to compare a filtered set of data with the original. In Y, I have the level of a tank and in X the date. As an example, I would say that I am filtering my level to be above 4000 liters and if the level is under 4000 liters, take the data out. After the filter, I have a set of data that the date are not all there, some have been filtered some my 2 sets of date are not identical anymore. Now, I want to compare the resulting curves between my original datas and my filtered ones. I was wondering if somebody knew how to do that in RM.
If it is impossible, I know it is not the same compagny so maybe my post will get deleted but I am asking, does anybody know a way to do it in Excel. RM is my first solution, but my second would be to write an Excel with my datas and do my plots in Excel if it is working.
Note: I know how to have multiples Y-axis in RM and a secondary axis in Excel, but I would like to have 2 X-axis to compare my curves in RM.
Thanks
0
Best Answer
-
MartinLiebig
Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,527 
RM Data Scientist
Hi @Process_Intern ,can't you simply rename you attribute and join the original data? Afterwards you can just do a normal chart with 2 y-axis?Attached is an example of the gas station data set. I remove all prices >1.40 Euro I get than this chart:
Isn't this what you try to get? Attached is the process and the chart config.Cheers,Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany5
Answers
We experimented with multiple X-axes, but it did get very confusing very quickly. Also, we allow some cool plot tricks, like adding more than one plot onto the same chart. For those reasons, we decided to not add the option of additional X-axes.
But from what I understand what you want to do, both Martins idea as well as adding multiple plots should work?
Regards,
Marco