Unable to get excepted result using the filter" Based on results of another analysis"

User_F6761

Hi,

I am having two analysis, they are

1. The table shows Lead details

2.Another report which shows the holiday lists with holiday name, From date and To date.From and to dates will be the same that is one day holiday and it will also have records with 3 continuous days as holidays.

I need to display the lead whichare created on holidays.

So i used filters "Based on results of another analysis" with great than and less than conditions for from and to dates comparing with lead creation date...

But the result is not based From and to date of each record in Holiday table.

Its taking From date of first record and to date of second record.

Holiday table

from                 to

----------       ---------------

5/04/2020    5/04/2020        - 1st Holiday

12/04/2020    15/04/2020    - 2nd-holiday record

Result

---------

Lead Table

Lead creation date

------------------------

5/04/2020

6/04/2020

7/04/2020

8/04/2020

9/04/2020

10/04/2020

.

.

.till 16/04/2020

Lead is shown