topic Re: Fetch logs from timestamp with filters in DQL

Fetch logs from timestamp with filters

AlexisGND — Fri, 08 Mar 2024 11:04:30 GMT

Hi,

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

I have a filter that contains numbers representing the day :

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 :

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 🙂

Re: Fetch logs from timestamp with filters

wouterdt — Fri, 08 Mar 2024 11:36:04 GMT

should you not use a casting function instead of concat?

Re: Fetch logs from timestamp with filters

AlexisGND — Mon, 11 Mar 2024 10:31:12 GMT

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.