Date Range selection

[Eleena]

Hi All

I have a scenario like i need to develop a table(having vehicle number and corresponding delivery date) for rolling  12 months . And  we need to select a date range in filter where the output should contains the vehicles having delivery date less than maximum  date range selected in filter.

Regards

Eleena

[shivanisapkale]

Hello,

Consider this sample data set

Load * Inline
[VechicleNumber,DeliveryDate
101,01/01/2019
102,02/04/2018
103,03/06/2018
104,04/08/2018,
105,05/08/2018];

Output :

PFA

[Eleena]

Thank you Shivani.

But we need all date data in filter (not only delivery dates) to select data range.And we need to get deliver dates in that data range  .  For example filter should contain 

Oct-18

Nov-18

Jan-19

Feb-19

Mar-19

and so on..

Regards

Eleena

[shivanisapkale]

Create a field by concatenating month and year and pass it instead of  "deliverydate"  and if you want 2 dates for a range then try this set analysis:

Count({<DeliveryDate={">=(min(DeliveryDate))<$(=$(max))"}>}distinct VechicleNumber)