Column of the dataset should not use filter

Q&A
,
1

I want to display max(date) from dataset, the dataset uses filter but I want this column to show max value irrespective of filter used in dataset how can this be done.

2

maxOver - Amazon Quick Suite maxOver(date, PRE_FILTER)

3

Hi @Hrolol @Xclipse I have created a calculated field

addDateTime (13, ‘HH’, maxOver({last_order_timestamp}, [ ] , PRE_FILTER))

Above is giving the maximum timestamp but that is not irrespective of filter apllied on that dataset

Please suggest me the way to diplay same and the visual which has feature to Aggregate as MAX and displays only latest order timestamp from dataset

4

Hi @Tanu_13

Could you please try this simplified calculated field? Remove the addDateTime wrapper and use maxOver with PRE_FILTER this ignores dataset filters and shows the global maximum timestamp from your dataset.

Example:

maxOver({last_order_timestamp}, , PRE_FILTER)

5

@Xclipse @Hrolol I have tried the same and found one thing, when filter selects a range for example - 1 Feb to 2 Feb, and the dataset has no data for that range in this case the latest time which is 31st January will not be visible in the visual. How to avoid this edge case

6

Hi @Tanu_13

This is expected behavior, PRE_FILTER computes only on filtered rows, so when the date range has no data, the visual appears empty.

To handle this edge case (e.g., filter Feb 1-2 but global max is Jan 31), create a separate dataset with just the global max date.

Example:

SELECT max(last_order_timestamp) as global_max_timestamp FROM your_table

7

Hi @Tanu_13

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

8

Hi @Tanu_13

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

Thank you!