Hello, I'm trying to use the Custom Question editor to build a query, so that I can have more dynamic access to dashboard filters and trying to summarize data by day of week and week of month. For some reason, the day of week has today's date as a prefix to the hour of day. Does anyone have any idea how to remove this?
Here are some screenshots of my query