Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Zoom in graph (line)

Received Response
21
Views
5
Comments
choracy69
choracy69 Rank 6 - Analytics Lead

Hi,

I have question zooming graph line.

On graph I have values close to 0 and on with very different value.

Something like that:

pastedImage_0.png

Can I do some good zooming for this graph?

I know that I can set ZOOM to RANGE or Zoom and Scroll for Horizontal and Vertical Axis - but this is not enough.

pastedImage_1.png

If I want zoom with scroll it is to 'long way' to show expected result.

Can I set maybe ZOOM/SCROLL VALUE for example: zoom graph in 5% or in 10%?

Or maybe someone have different solution?

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Zoom isn't the issue ... data visualization design principles are not coming into play - that's your issue.

    Even if you get 'zoomed' you are going to have too many lines for anyone to make sense out of ...in any case, have you tried force setting a minimum on the Y axis?

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Maybe a bit of a long shot, but you could also try using the "logarithmic scale", if it is available on this graph. I have seen that help with our graphs that have extreme value disparities ...

    Charles

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Unfortunetaly, data is correct and the visualization is correct - we have one unexpected value for one branch and thats the problem. I can uncheck this branch in filter but it is wrong option. I am thinking about ZOOM graph in percent...

  • Charles M
    Charles M Rank 6 - Analytics Lead

    choracy69,

    Did you try using the logarithmic scale? Again, I am not sure if it is available for  version and/or this graph type. But, it is worth checking into. It can "smooth" out the values which are otherwise so far apart. It's an easy attempt ... only one checkbox to change (revert back the same way, if it doesn't help. Please try and post the results.

    Charles

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    what about 'removing' the outlier and then having a sibling analysis that highlights the 'removed' outlier?