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.
Plot view
mengkoon007
Member Posts: 30 Contributor II
Hi,
I am using the graph in rapidminer to try visualize my data.
I created a process and the data view shows:
Year Staff MC
2013 A001 1
2013 A001 2
2014 A002 4
2015 A003 5
2016 A004 6
2017 A002 3
Example: I am trying to show a chart the average MC was taken for each year. Below is the output chart I got.
Questions:
- I have value for 2016 and 2017, why there is no bar showing?
- For 2013, I have a total of 93 counts and the MC sum value is 374. The value should it not be 374/93 = 4.0215?
- Is there any function that can show what is the value of the bar? Eg. roll over the mouse on the bar?
- Does all the attribute needs to be converted to nominal type for the chart to work?
Thanks.
Chart:
Tagged:
0
Answers
Do you have multiple records for the year 2016 and 2017? When you use Group by Year, it will aggregate by year and then use the average (as you set). Double check that.
Also, are you running V5.3? If you are, you should upgrade to 7.3. More faster and better.
Hi,
Below are the records for 2016 and 2017.
Year Staff MC
2016 A001 1
2016 A001 1
2017 A002 1
I don't quite get the following statement:
When you use Group by Year, it will aggregate by year and then use the average (as you set)
Can kindly show me an example what should be plot in this case?
x-axis = Year
y-axis = MC
Average MC for 2016: 1 (total MC for 2016 / total count for 2016 = 2/2 = 1)
Average MC for 2017: 1 (total MC for 2017 / total count for 2017 = 1/1 = 1)
Hi,
If my assumption is correct, I think I know why I could not get the average MC for each year using the bar chart. The MC type was "nominal" and after I revert back to "real" type, the display is correct.
May I check how can I display the value in "Data View" as below but the type still remain real?
I always used "Format Numbers" operator to show the pattern and it will change the type to nominal.