Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
jsl@actinet.cz Respected Contributor.
Respected Contributor.
252 views

How to turn over Z axis on stacked area (or ORDER Z-A)

Hello,

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...

Labels (2)
0 Likes
3 Replies
Gayan Acclaimed Contributor.
Acclaimed Contributor.

Re: How to turn over Z axis on stacked area (or ORDER Z-A)

Hi Jan

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

Cheers

Gayan.

Mr
0 Likes
jsl@actinet.cz Respected Contributor.
Respected Contributor.

Re: How to turn over Z axis on stacked area (or ORDER Z-A)

Hello Gayan,
I tried to modify query (in mine, there was only difference with ORDER BY Action...) and made all the trends all new and was happy at the beginning - everything looked perfect - but after the trends got more populated, graph switched on to its head again...
So it looks, that Arcsight just interprets data as it likes without possibility to change it anyhow:=(.
In original question added pictures of progress - ok was 4.12.-12.12., but turned when was 3.12.-12.12.
0 Likes
jsl@actinet.cz Respected Contributor.
Respected Contributor.

Re: How to turn over Z axis on stacked area (or ORDER Z-A)

I have opened a ticket, problem goes to developers...

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.