Create a chart with stacked success status and status>500

[marco_carolo]

Hello there.

I've a series of GET/POST request.

The request is to have inside the dashboard a stacked column graph that shows, per server, the values of successfull request below and above them the failed request (with status > 500)

What I'm doing is the following:

| chart count(eval(tonumber(status)>=500)) as internal_errors, count as total_requests by host | eval safe_requests=total_requests-internal_errors | table host, safe_requests, internal_errors

 Is there any better way to do that?

Second question:

In the result I'm having, I'm having the internal_errors displayed before the larger (hope that stays so) successfull count of total requests...

You can see in the first 2 servers...

Any way to change this order?

Third question:

Is it possible to define 2 sets of color (eg Green and Red) for stacked values?

Edit: Thanks for any reply!

[marco_carolo]

Solved the query part:

| chart count(eval(status>=500)) as internal_errors, count(eval(status<500)) as other_requests by host

What about the colors? Is there any way to define them?