Plot view

mengkoon007mengkoon007 Member Posts: 30 Contributor I
edited November 2018 in Help

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:

  1. I have value for 2016 and 2017, why there is no bar showing?
  2. 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?
  3. Is there any function that can show what is the value of the bar? Eg. roll over the mouse on the bar?
  4. Does all the attribute needs to be converted to nominal type for the chart to work?

Thanks.

 

Chart:

Bar chart.jpg

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    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.

  • mengkoon007mengkoon007 Member Posts: 30 Contributor I

    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) 

  • mengkoon007mengkoon007 Member Posts: 30 Contributor I

    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?

    1. 2 decimal (1.00) => pattern: 0.00
    2. Add icon % (1.00%) => pattern:0.00%

    I always used "Format Numbers" operator to show the pattern and it will change the type to nominal.

Sign In or Register to comment.