Fetch logs from timestamp with filters

Platform DQL
, ,
1

Hi,

I created a dashboard with is counting the number of raw per hours with personnalized ingested data.

AlexisGND_3-1709895550612.png

I have a filter that contains numbers representing the day :

AlexisGND_2-1709895412595.png
AlexisGND_2-1709895412595.png161×900 12 KB

And my wish is to set the timestamp day filtering of these counting tiles, with the one selected in the filter, but there is a problem :

AlexisGND_1-1709895371532.png
AlexisGND_1-1709895371532.png709×154 13.7 KB

The idea is not to set the global timeframe of the dashboard to the beginning of the year (takes too long), that’s why i want every tiles to get the day of the filter in case i want to switch between yesterday and other previous days.

Is this even possible ? or is there another way to do it ?

Thanks in advance for your response :slightly_smiling_face:

2

should you not use a casting function instead of concat?

3

At the end, it worked with the concat :

fetch logs, from: toTimestamp(concat($Year, “-”, $Month, “-”, $Day, “T00:00:00.000Z”)), to: toTimestamp(concat($Year, “-”, $Month, “-”, $Day, “T23:59:59.000Z”))

I don’t possess enough technical knowledge of dql for using casting function and I think it’s not adapted with my situation, maybe I am wrong.

But the end result is what I wanted.
Thanks for your idea, I will work on the casting function, see if it’s more optimized or not.