Can I determine how many FTEs we have on assignment each month?

[Danielle Wentworth]

Hi. We currently track the number of FTEs (full-time employees) on client assignments. To do so, we have an FTE custom field and add assignments on the board with the start and end dates of the assignment. I am trying to create a dashboard that shows the total number of FTEs on assignment each month.

Picture below of the information that we collect. Another picture of the excel information that we manually pull that I am trying to turn into a dashboard, preferably a chart with the total number of FTEs each month. Since the timeline already lays out our assignments based on month, I would think this would be possible to see FTE by month but not sure how.

[Bill Sheboy]

Hi @Danielle Wentworth -- Welcome to the Atlassian Community!

I do not believe you can do that, in the way you are presenting the information, with built-in dashboard gadgets.  Perhaps investigate the Atlassian Marketplace for addon gadgets / reports to help with specific staff assignments management.

You could try creating queries for each month, going backwards relatively (e.g., -1m, -2m...) using JQL functions: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--  However I wonder how you handle any re-assignments during the windows, using the fields you noted for start/end date of assignments.  Changes to Jira fields are captured in the issue history, yet most of those changes cannot be queried...making those changes invisible to JQL-based reporting.

Kind regards,
Bill