Visualizing the results of an SQL query

ProzachProzach Member Posts: 2 Contributor I
edited November 2018 in Help
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

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,525   Unicorn
    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
Sign In or Register to comment.