Issue Rendering Legends

Grafana Time Series Panel
1
  • What Grafana version and what operating system are you using?
    Grafana Cloud
  • What are you trying to achieve?
    I am trying to display legends as “graph”, “businesslogic”, “fetch” etc.
  • How are you trying to achieve it?
    I have a DB Table with below values

image
image955×211 7.38 KB

Below is the query
select
queue_name from QueueMonitor
where queue_name IN (‘graph’, ‘triggers’, ‘publiclink’, ‘publisher’, ‘businesslogic’, ‘renditions’, ‘fetch’, ‘actions’)
AND $__timeFilter(timestamp)

  • What happened?
    I am only viewing “value” as one of the legend or my be not.

  • What did you expect to happen?
    I was expecting to have “graph”, “businesslogic”, “fetch” etc. as legend

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    There are no error

  • Did you follow any online instructions? If so, what is the URL?
    Create a dashboard | Grafana documentation

Add variables | Grafana documentation

2

Hello cellyamit , i understand your problem and facing same issues using disply name , i try to solve your problem using grafana variable and then use transformation to achive your requirement.
follow the step to solve this issues
Step 1 : Add variable and configure it.

image
image349×486 18.7 KB

image
image372×454 23.3 KB

Step 2: Write query to fetch data from db table
image
image996×230 17.6 KB

Step 3: Add these transformation
image
image1017×222 18.4 KB

Final output
image
image507×293 8.81 KB

3

Dear @infofcc3
Thank you so much for your prompt reply and I highly appreciate your support.

Based on the suggestion I am to view the expected result

image
image1252×312 19.2 KB

Though results are as expected however, I am wondering, I am able to view the dots-flow, but what is it that is restricting to display line chart.
Could you please share your insights?

Best Regards,
cellyamit

4

Hello @infofcc3
I was able to get lines displayed, refer the below screengrab

image
image1864×715 83.7 KB

Further, I just observed a scenario that on refresh, graph flickers due to number of selected value in variable i.e. $fetchQueue, is there a possibility to hide variable list and let it be dynamically get displays as legend, so to avoid the flickering.
Let me know if this makes sense.

Looking forward for your support.

Best Regards,
cellyamit

5

My Apologies. but I was able to hide the variable.
This should be my last comment, but once again, I would like to extend my gratitude for you in providing your expert advice and suggestion.
Many thanks!!

Best Regards,
cellyamit

6

Thanks for your feedback @cellyamit