bars plotter

currant
currant New Altair Community Member
edited November 5 in Community Q&A
Dear All!

I have to evaluate two surveys which were  conducted in 2006 and in 2011. All data (questions, answers, ...) is in MS Access. I want to use RapidMiner to e.g.  compare the results graphically from 2006 and 2011.
Now, I have a result table as follows:
Answer  Year  Number of Answers
answer1  2006  26
answer1 2011 55
answer2  2006  115
answer2  2011  134
my question:
Is it possible to design the "Bars Plotter" in such a way that for one answer the number of answers from 2006 and 2011 appear next to each other and for the second answer in the same way?
In Excel, this is possible...

Thanks in advance!

currant
Tagged:

Answers

  • homburg
    homburg New Altair Community Member
    Hi currant.

    As far as I know there is currently no plotter which does exactly what you described. But the Bars Stacked may also work for this kind of purpose. It just stacks the bars instead of lining them up. Just try it and select the following parameters:
    Group-By Column: Answer
    Stack Column: Year
    Legend Column: Answer
    Value Column: Number of Answers
    Best regards,
       Helge
  • currant
    currant New Altair Community Member
    Hi Helge,

    Thanx a lot!

    Do you know if this is possible with RapidAnalytics?

    currant
  • IngoRM
    IngoRM New Altair Community Member
    Hi,

    this type of grouped bar chart is indeed possible with RapidAnalytics. Look at this video:

    http://www.youtube.com/watch?v=2HnK777XAHI

    In the lower left part of the style bundle definitions you can see the desired chart type if I am not mistaken.

    Cheers,
    Ingo