Apply Datetime filters based on User's Local Timezone rather than UTC

What is the problem or goal the end user is trying to solve or accomplish?

Currently, when applying a custom Time Filter, it uses UTC time. For example, `now`, `midnight` etc is applied on UTC. It's common for users to connect data that is on another timezone.

How are they solving it currently?

Users need to take the conversion into consideration or apply custom SQL.

What is the recommended solution by the Customer?

Provide the ability to use the user's timezone instead of using UTC.