How to make a summary table to a day level table

[Woody Wu]

I have a summray table with the startand end dates of all the jobs as below:

job name start date end date

JobA 02/21/21 02/28/21

job B 01/23/21 01/28/21

How can I convert the summary table to a day level table with a "status" columnin which it would show "yes" if the date in "date" column arebetween start and end date in the summary table:

job name date status

Job A 02/20/21 no

job A 02/21/21 yes

job A 02/22/21 yes

....

job A 02/28/21 yes

job A 03/01/21 yes

Thanks,

[Fabian Duerr]

Please check the following discussions:

https://community.tibco.com/questions/visual-count-active-rows-over-time...

https://community.tibco.com/questions/counts-over-time