How to turn over Z axis on stacked area (or ORDER Z-A)
I need to build report with connection count trend over month (netflow-like), graph should represent accepted and dropped packets in stacked area graph. I ran into a problem, that accepted packets are on bottom of a stack and dropped packets are on top and I'm not able to turn it over. I have tried to change order of NAME, which contains the drops and accepts, but graph stays the same...
Is there any way to do it? I simply need the green at the bottom and red on top (don't mind the colors). Any help is appreciated.
Excuse my English...
Re: How to turn over Z axis on stacked area (or ORDER Z-A)
It seems your query is wrong. Just make sure select [sum aggregatedevent , action, (timestamp)day] groupby [action, timestamp)day]
then in the report select x- timestamp)day, y- eventtotal and z- action