marcusolsson / grafana-gantt-panel

A panel plugin for Grafana to visualize Gantt charts.
Apache License 2.0
26 stars 12 forks source link

Nothing plotted due to incorrect parse of the results #33

Closed felixmondelo closed 3 years ago

felixmondelo commented 3 years ago

Hi,

Sometimes nothing is plotted due to an incorrect parse of the query result, it mixes in the header data from other columns:

image

Usually, it works fine and plots the results and the results data are on each column:

image

How can I fix this?

marcusolsson commented 3 years ago

Thanks for sharing! Though I'm not sure I understand. In the first example, it looks like you're using a Time series format, and in the second example you're using Table format? This doesn't look like an issue with the Gantt panel, but with your query/data source? Could you provide more details? Ideally so that I can reproduce this myself.

felixmondelo commented 3 years ago

The queries are against Azure Data Explorer and both are the same query but with several time ranges. I don't know why sometimes with some filter, I receive:

image

When I inspect the Data, I saw that when the Gant fails is because the data is formatted as:

image

And when works, the data is formatted:

image

If I launch both queries on ADX the structure is equal:

This fails:

image

This works:

image

How can I help you?

marcusolsson commented 3 years ago

That does sound weird. The Gantt panel only works if you've set Format as to Table. If you're getting time series data even when you've set it to return Table data, it sounds like it could be an issue in ADX. Maybe @joshhunt can weigh in here?

felixmondelo commented 3 years ago

Yes, I think was that format the query to Table ... It seems now works, I continue testing ... Thank you so much!