Skip to content
Free download Try cloud
Try cloud

Unable to select X & Y columns to plot chart after running query

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • August 16, 2023 at 6:21 pm #411
    jkanalakis
    Guest

    I have everything installed and running correctly.
    I can connect a MySQL data source and add a new panel.
    I enter the chart settings and successfully run a query.
    I see the preview chart and the table data in the center of the page.

    PROBLEM
    In the left panel, expanding “Trace 1” and expanding “Analytics” there are two dropdown menus that indicate “ID” but are disabled. I can not select the columns for the X and Y values to plot in the chart. What could possible cause these dropdown controls to be disabled?

    The second image shows the Javascript console with an error reported at the top. Could that be related?

    August 16, 2023 at 7:39 pm #412
    George Lewis
    Moderator

    The Analytic functions only when you place a Date type field in the X axis AND values in the Y axis.

    August 16, 2023 at 11:45 pm #413
    jkanalakis
    Guest

    Very good point. I didn’t notice that those X & Y drop-down boxes disappeared. It looks like I have some JS issues from upgrading the Bootstrap library. It almost looks like the bootstrap-select is loading before bootstrap and causing the JavaScript error.

    Thank you for pointing me in the right direction. I’ll explore that a bit more. If you have any other advice for updating Bootstrap or JQuery, I would love to know.

    Thank you,

    John K.

    August 17, 2023 at 5:43 am #414
    George Lewis
    Moderator

    It seems that you are using a headerless, data-only Excel file. If so then you should define headers in your file and then use it.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Dashboard Builder works wherever you do.

Get Dashboard Builder freeFor your server, the cloud and Windows