0

Line Graph: Continuous X-Axis

I have values on my x axis: 0,5,20,50,100,250,500,750,1000,1500 and they are represented as discrete points, equally spaced. Is there a way to make them continuous?

I have the x-axis values in the Categories drop zone (Dimension) and the values in the Y1 drop zone. I'm guessing that the x-axis values defined as a dimension is causing my issue. 

9 replies

null
    • Sharon_Flanagan
    • 3 yrs ago
    • Reported - view

    For a continuous plot, missing values should be interpolated to connect one point to the next.

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Can you upload some images or an example. Its not clear what you are after.

    • Sharon_Flanagan
    • 3 yrs ago
    • Reported - view

    The top graph is what my user would like to see (from a python program): the x-axis has the same distance between each marking (so you get a curve instead of a straight line).

    The second graph is the implementation in pyramid, where the x-axis has the discrete data points.

    I think it may be a problem with the implementation of the model -- the user who set it up defined 'X' as a dimension. It represents milliseconds and has 10 values ranging from 0 to 1500.

    So, in a nutshell, is there a way to get the x-axis to go from 0 to 1500 by 200?

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    First, you can change the "tick" interval but only for the y-axis, which is the numerical axis. If your X is categorical, then, there is no such thing. You can fudge it by shrinking the size of the chart - which will auto-collapse the number of visible categories.

    Second, the first chart is maybe smaller and more compact, hiding the true values. If you draw this in Excel, which chart does it look like? if you expand the full chart, how does it look.

    The concept of "continuous" values is a little strange. I think what you want is to "smooth" the data. That can be done with some functions and logic, if you really want to iron out the bumps. 

    • Sharon_Flanagan
    • 3 yrs ago
    • Reported - view

    Thanks! I'll share your feedback with the developer.

    • Sharon_Flanagan
    • 3 yrs ago
    • Reported - view

    If I put the data into excel, the x access would be interpreted as a series and the values would be interpolated (like matplotlib). This is the two lines added together.

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    So this explains it.

    You're drawing a scatter plot (with lines) - not a classic Cartesian line chart. If you were to draw the scatter in Pyramid you'd see the same curve. The only thing missing, unfortunately, is the connective line - which is not a capability we currently support. 

    If you'd like this option, please post a request in the new ideas section on the forum.

    • Sharon_Flanagan
    • 3 yrs ago
    • Reported - view

    Thank you -- I'll post that request.

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    This feature has been added with release 2020.13.

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 9Replies
  • 60Views
  • 2 Following