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
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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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 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