How to plot graph for non time series data as X axis

[ikhlaque26]

HI
I am new to Grafana.
I wants to plot a graph for below mentioned MySql table

Y axis as ExecutionTime and X axis as TestName or TestID.

Could someone help me on this.

Thanks in advance

[anon34853223]

Hi,

Please use X-axis mode series.

Marcus

[ikhlaque26]

Hi Marcus
I manage to plot Bar like

But I wanted to have a graph like

When I executed the below query query , I get null value for series.
could you please help me ,to plot the graph

SELECT
UNIX_TIMESTAMP(ExecutedAt) as time_sec,
TestExecutionTime/1000 as value,
TestName as metric
FROM mqa_performance_msql_db01.tbl_tests
WHERE TestName=‘UserLogin’ and $__timeFilter(ExecutedAt)
ORDER BY ExecutedAt ASC

[anon34853223]

You probably need to group by executedAs and testname. But it seems like your where clause are making the query match no rows?

[ikhlaque26]

when I exclude $__timeFilter(ExecutedAt) from the query then rows are returned but with error on panel as “Data point outside time range”

and when i add $__timeFilter(ExecutedAt) in where clause no rows are returned.

ExecutedAt are not in fix interval , does it make any difference ?

[anon34853223]

Probably timezone related. What timezone on grafana server vs mysql server? Quick workaround could be timeshift 1h

[kfrench]

Good info @anon34853223! Your link seems to be slightly outdated (likely due to a wording change by the webpage manager). Could you update the link to this when you get a second?

[dsb]

Need to piggy-back here. I’m having a similar issue to original poster. My dataset comes back but is graphed as if each day is its own series, where I would like it treated as a single series. is there a way to accomplish this? I’m not particular about whether it’s a bar or a line graph, I just want this series to return all the same color:

[danielgonzalez]

you can try serier override, here I explain it briefly

[mayurmanurkar]

How did u managed to get the “bar” chart ? … i am facing problem here

[sonnenterasse]

Hello
Can anyone help me how to make bar chart with the amount every month from this datas?

[ashwinipattarjun18]

Hi can you plz show me how u did this .