question

Ozan Yilmaz avatar image
Ozan Yilmaz asked

How to write this in kusto language (Data explorer)?

Hello everyone,

In our game, we use custom events to collect some data. Everything works fine, however I want to get the custom events by their dates. For example; I only want the data that were created in May 30th 2021.

where Timestamp > ago(1d)

Currently, I'm using the code above, however, it can't get all the data from May 30th 2021 depending on when I execute that code. It only goes back to 24 hours. What kind of filter should I apply to achieve what I want?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Ivan Cai avatar image
Ivan Cai answered

In your case, you can modify the query code as follows:

| where Timestamp > datetime(2021-05-30)and Timestamp < datetime(2021-05-31)

Or, you can try to implement it on the Data Explorer(basic), please refer to the picture below:

If you want to learn more about kusto language, please refer to https://docs.microsoft.com/en-us/azure/data-explorer/kusto/concepts/.


foryan221.png (29.4 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.