Woody Wu Posted February 7, 2022 Share Posted February 7, 2022 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, Link to comment Share on other sites More sharing options...
Fabian Duerr Posted February 9, 2022 Share Posted February 9, 2022 Please check the following discussions: https://community.tibco.com/questions/visual-count-active-rows-over-time... https://community.tibco.com/questions/counts-over-time Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now