Mauri Sutton Posted January 19, 2021 Share Posted January 19, 2021 Our queue of tickets has submission dates, start dates, end dates. Some tickets are in waiting, some are in process. (BOTH are considered part of the "queue" until they are closed) I simply want to plot to total number of tickets in queue at 8AM on each day. Or 8AM on monday of each week. Seems simple but for some reason I can't figure it out. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted January 20, 2021 Share Posted January 20, 2021 I think it's not that simple. In particular when your tickets can be queued over several days.... You could write a data function that checks for each day (of your total date range) the status of your ticket at 8AM (basically the end dates) in your data set. Then you can count all tickets that are queued for each day and finally return a new data table with the results. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 20, 2021 Share Posted January 20, 2021 This previous answer might help - uses a TERR data function. The original question was to coun the open tasks for each date. https://community.spotfire.com/questions/creating-daily-timeline-show-numbe... 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