Can I create a custom filter on a date field?

Q&A
, ,
1

Hello!
I am trying to create a filter for “snapshot_timestamp” field (date type) to include only the latest date, however I can’t find the option of custom filter for a date type field. Do you have any suggestion please?
Thanks,
Caterina

2

Hi @Cate95 and Welcome to the Quick Sight Community!

In this instance, would there be a customer field that may have multiple snapshot timestamps and you are trying to only populate the most recent?

If this is the case, while there is not a filter control that can be setup, you can accomplish this by using a calculated field:

maxOver({snapshot_timestamp}, [Customer], PRE_AGG)

(For you, ‘Customer’ would be replaced with the field you are looking to filter down).

Let me know if this helps accomplish what you’re trying to do or if you have any further questions.

Thank you!

3

Thanks Duncan for this, however I’m still not excluding the data from older snapshot timestamps. How can I filter them out?

Thank you!

4

Hi @Cate95,
If you’d like to remove the other options, you can replace your original ‘snapshot_timestamp’ field with the new calculated field and it will just give you the most recent.

Thank you!

5

Hi @Cate95,
It’s been awhile since we last heard from you. Checking in to see if you had any additional questions regarding your initial topic?

If we don’t hear back within the next 3 business days, I’ll go ahead and mark the solution.

Thank you!

6

Hi @Cate95,
Since we have not heard back from you, I’ll go ahead and mark this as solved. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information.

Thank you!