Hours-Level Filtering for Datetime Columns

[bminehart]

This is for LiveConnect data sources using Snowflake.

We cannot filter Datetime columns at the hours level. Either "last n" hours or "between 08:00-12:00" as example.

I would like to see this added as a capability of filters.

[sumeetsingh]

+1

[YuliyaMotiyets]

Hello @bminehart 

Thank you for sharing your idea in the Sisense Community. We value your input and think this is a great idea! 

In order to prioritize our development efforts, we want to gauge community interest. We kindly request you to encourage other users to vote and comment on your suggestion. The more engagement your request receives, the higher the likelihood it has of being considered for implementation.

We appreciate your efforts!

Best, 

Yuliya

[DRay]

Hello @bminehart,

I found this post from one of our partners that addresses this. Does this solution work for your use case?

https://community.sisense.com/t5/embed-analytics/filtering-for-last-2-hours/m-p/5000

[bminehart]

Hi @DRay - I looked at the link. We don't use EC, we use Live Data Models. I'm not sure that @Benji_PaldiTeam 's suggestion would work for us?

[DRay]

Hi @bminehart,

Sorry, I missed that detail. I don't know if it's possible right now with Live Models. We will keep you posted as the product team looks into this.

[omeron]

+1 on this. It seems strange to require data modeling for a simple thing as filtering by hours.