Skip to Content
0
Nov 05, 2018 at 07:56 PM

Find Number of Holidays between Two Dates in Webi

475 Views

We have two DataSource: 1. SQL 2. Universe

From SQL we fetch data containing Columns Start Date and End Date. We want to find Number of Holidays between Start Date and End Date for all the rows.

To Know the list of Holidays we have universe which has a Date Column and a Column to Mark "Y" for Holiday and "N" for not a holiday.

Note: We want to do the calculation in Webi only and Not at the universe level.