This message was deleted.
# generals
Slackbot
12/27/2022, 7:14 PMThis message was deleted.
b
Ben Krug
12/27/2022, 8:46 PMI'm not sure, but maybe something with a CASE statement and FILTER clauses? The case might not be necessary, maybe just FILTERs for each aggregation and timezone, getting different columns (for each timezone).
b
Brandon Tan
12/28/2022, 2:19 AMHi Rishi, can you share some pseudo code on your logic ? Thanks !
r
Rishi Rana
01/10/2023, 7:52 PMSorry I was out
Rishi Rana
01/10/2023, 7:53 PMSo I have a table which contains data in UTC, each row has a column based on which it identifies the timezone for that particular row, so what I need is to be able to query each row in its respective timezone for LastNDays
b
Ben Krug
01/10/2023, 10:27 PMcommented in #C0303FDCZEZ - https://apachedruidworkspace.slack.com/archives/C0303FDCZEZ/p1673380301176109