Number of open tasks - past month
Hi, I have been trying to compare with an indicator how many tasks are open this month and then as a secondary how many tasks were open last month. I am trying to gauge the activity in a specific space. I can do the number of open tasks in the current month but I am having trouble figuring out how to get the number of open tasks in the past month. Thanks for your help.
Are you using the report function? If so, have you tried using the filters for Started Date and/or Completed Date and putting in a custom timeframe?
I have not that sounds like a smart way of doing it, I didn't think of that. Thank you i'll let you know if it works.
Hi, if you're using Analyze I suggest you set the filters to "create date" this and last month.
In a table then insert the value "create date" as a column as month