[Elasticsearch Datasource]: Compare 3 diffrent selected time ranges

[mehdira]

• What Grafana version and what operating system are you using?
  Grafana version: v9.4.7

• What are you trying to achieve?
  I Want to grab the data from Elasticsearch at different times of one source and field then align and compare them together.

• How are you trying to achieve it?
  I have 3 different queries:

1. Today’s data query:

   (http.request.host: wildcard* OR http.request.host: wildcard*)
   AND @timestamp: [now-1d/d TO now+1d/d]
   

2. Yesterday’s data query:

   (http.request.host: wildcard* OR http.request.host: wildcard*)
   AND @timestamp: [now-2d/d TO now-1d/d]
   

3. One week before same day query:

   (http.request.host: wildcard* OR http.request.host: wildcard*)
   AND @timestamp: [now-7d/d TO now-6d/d]
   

• What happened?
  The result is something like:
  

  
  
  As you can see the queries data are separated because they are grouped with date and the dates are different.

• What did you expect to happen?
  To Compare these queries together.

I’m spending hours and hours but there was any way to align them together unless I can remove the date part from the timestamp.