Issue validation

I’ve been struggling with an issue for quite some time now.

Our datasource is connected to Grafana. To validate it against our current system, I extracted a sample with two columns: ‘itemcode’ and ‘pickup_date’ without any specific conditions. Upon opening this data sample in Excel, I found that the count matches perfectly with our system, which was great news.

However, when I proceeded to create a time series visualization and counted it within Grafana, I noticed a discrepancy in the date count compared to what Excel showed me. Despite spending the entire week attempting to validate this issue, I haven’t been able to find a resolution.

What version of grafana do you have and what datasource and can you please share your query and what filter are you using

Grafana v9.5.13 , DMZ server ,

this is the query "
COUNT(*) AS shipment_count,
CAST([PICKup_Date] AS DATE) AS pickup_date
CAST([PICKup_Date] AS DATE); "

and this is the result " i highlight date 04/11/2023 to just validate "

and if i just extract as this as cvs file "
ItemCode , PICKup_Date


for date ’ 04/11/2023 ’

I’ve tried all the methods that I thought would have an effect. I attempted counting with just the PICKup_Date without casting it, with the cast, and with CONVERT , but none of these matched the count in Excel

what filter are you using in excel? show us the filter choice please

i just use the filter to see the count number on date 04/11/2023

it seems the issue with the date it’s self , but i couldn’t fix it

1 Like

Your query removes the time part


Your excel does not. You are comparing apples and oranges. Ttry to remove the time part in excel

the same issue :frowning:

What time range are you using in grafana time picker?

And are you using ms sql or mysel?

What do you see when you click on query inspector

What time range are you using in grafana time picker?
the time range that i’m using is the filter ’ today so far, or the last 24h ’ i try to apply different range and i try to change the time zone nothing happen also
Browser Time is Antarctica , and the time range

And are you using ms sql or mysel?
ms sql

What do you mean in your last question ?

1 Like

For testing please add a where clause with

Where pickup_date between 
'04/11/2023' and  '04/12/2023'

the same thing , nothing change

1 Like

it’s so weird and i couldn’t understand the script is right but it give different format