Hours-Level Filtering for Datetime Columns

Product Feedback Forum

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.

bminehart

Posted 3 years ago·Last reply 1 year ago

6 comments

omeron

·1 year ago

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

DRay

·1 year ago

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.

bminehart

OP1 year ago

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

·2 years ago

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

Yuliya Motiyets

·2 years ago

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

sumeetsingh

·3 years ago