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

  • jkanalakis
  • jkanalakis's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 3 months ago - 1 year 3 months ago #57 by jkanalakis
jkanalakis created the topic: Unable to select X & Y columns to plot chart after running query
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?
Last Edit: 1 year 3 months ago by george.

Please Log in to join the conversation.

More
1 year 3 months ago #58 by george
george replied the topic: Unable to select X & Y columns to plot chart after running query
The Analytic functions only when you place a Date type field in the X axis AND values in the Y axis.

Please Log in to join the conversation.

  • jkanalakis
  • jkanalakis's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 3 months ago #59 by jkanalakis
jkanalakis replied the topic: Unable to select X & Y columns to plot chart after running query
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.

Please Log in to join the conversation.

More
1 year 3 months ago #60 by george
george replied the topic: Unable to select X & Y columns to plot chart after running query
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.

Please Log in to join the conversation.

Time to create page: 0.073 seconds

Connect with us (chain_app_template)

1 E Erie St Ste 525, Chicago, IL 60611

(815)556-9255

support@dashboardbuilder.net

Mon-Fri: 9am to 6:pm EST