Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BarryG
Contributor
Contributor

Need to create a graph, showing, Started, Closed and backlog measures by year-month

My Data columns in the source sheet are like this:

 

BarryG_1-1655375091347.png

I want to be able to count the opened, closed and backlog columns and plot them by the Product or as the totals (without breaking down by products). I have seen some examples of whileloop and use of IterNo functions. I am not too familiar with those. Can someone please share any solution for this. I seen references to @Henric_Cronström  by some, but can't get to the reasonable solution. Will very much appreciate any insights or assistance.

 

Labels (3)
1 Reply
BarryG
Contributor
Contributor
Author

One more thing to add, there will be other statuses for the projects like 'Active', 'On-Hold', 'Cancelled' etc., But I am mainly doing the difference between the new ones, the completed ones showing the delta or backlogs.

 

Thank You