Visualizing the results of an SQL query

Prozach
Prozach New Altair Community Member
edited November 5 in Community Q&A
image
The picture is the format I am going for.

The data comes out already pivoted once and produces a dataset consisting of 4 columns
date|state|total error|error change|

What I would like to get is the result in the picture but I am not sure how to go about this or if rapid miner is even the appropriate tool.

I'd be appreciative of any help or suggestions anyone might have
Tagged:

Answers

  • land
    land New Altair Community Member
    Hi,
    you can solve this with the Reporting Extension in combination with an custom HTML Template. You could generate a Plot per state and write them into an HTML table. But there is no out of the box solution currently for RapidMiner.
    We have another tool called RapidLab, also developed originally for engineering for having a dashboard of diagrams to supervise and analyse machine work by interacting with the graphs, you could configure it to display these bar charts. But if this plot is the only one you need, you probably don't need such a big gun...

    Greetings,
      Sebastian