2 Xaxis and 2 Yaxis plot.
Process_Intern
Member Posts: 13 Contributor I
in Help
Hi all,
I was wondering if somebody would know if it is possible to do a plot with 2 Xaxis and 2Yaxis 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 Yaxis in RM and a secondary axis in Excel, but I would like to have 2 Xaxis to compare my curves in RM.
Thanks
I was wondering if somebody would know if it is possible to do a plot with 2 Xaxis and 2Yaxis 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 Yaxis in RM and a secondary axis in Excel, but I would like to have 2 Xaxis to compare my curves in RM.
Thanks
0
Best Answer

MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,453 RM Data ScientistHi @Process_Intern ,can't you simply rename you attribute and join the original data? Afterwards you can just do a normal chart with 2 yaxis?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 Xaxes, 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 Xaxes.
But from what I understand what you want to do, both Martins idea as well as adding multiple plots should work?
Regards,
Marco