Open items between two dates (Which are fields)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jcollare
5 - Atom
‎06-04-2024
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all! I have an issue I am really struggling with.
I have two dates, basically, a start date and an end date. The time between two dates, the event was open. Each event has a different start date and different end date. I need to make a trend line to show how many events were open on a given date. So if the start date was 6/1/23 and the end date was 6/30/23, I need that to show open on my trend line for that period of time in between. Any ideas?
Thanks in advace!
Labels:
2 REPLIES 2
21 - Polaris
‎06-04-2024
04:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jcollare
It will be better if you could provide some sample input and output so we can take a closer look.
terry10
12 - Quasar
‎06-04-2024
05:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use the Generate Rows tool. Example workflow attached.
If my reply helped you, please mark it accepted. Thanks!
