How to select the latest or max date from a selected date range

[siddharth sabat]

Hi,

I have often encountered various situations where I need to select the latest or max date based on aselected date range.Here is the situation..

Lets say I have a dataset with records ranging from 1st Jan 2021 to 30th Nov 2021. I want to restrict my visualization (either the table, pie chart or a bar chart) to load only data for the latest date based on the daterange I select (the end date here is less than the latest date availabe in the dataset i.e. = 30th Nov 2021). But If I select thedate filter with an end date