Create a dashboard to compare the data of two or more dates

@karenmiller @daniel9727 @dcech

  • What Grafana version and what operating system are you using?
    Grafana 9 on linux
    datasource: Mysql/PG
  • What are you trying to achieve?
    I have following data

Columns name are Task_name, execution_time, Date_ofExecution.
I want to compare the what is the execution time of each task on each date.
Ex: Compare the execution time of the join rule.
on the same graph it should float 2 lines for a join rule
1 st line for date 1
and 2nd line for date 2
something like this.

  • How are you trying to achieve it?
    I don’t have much knowledge about sql queries, currently i am getting following

Can some one guide me how can i achieve this.