How do i get a report on ONE field?

[Sandy Helmer]

I am trying to pull a report for the field of "AMS Tracking time" on a weekly basis. I only want to run it for one project with the main issue and the "Open" child issues.

[Pasam Venkateshwarrao]

Hello @Sandy Helmer 

Welcome to the community,you can use the below query to pull the report of the AMS Tracking time for weekly

project = "My project" and AMS Tracking time is not null and updated > startOfWeek("-1") and assignee was CurrentUser()

Hope this helps 

[Mathew Lederman]

@Sandy Helmer you can create a filter with your requirements and remove all other fields from the columns list. Once the filter is saved, you can create subscribe to the filter to send to whomever you like on whatever schedule you would like.

[Sandy Helmer]

Mathew, 

This ALMOST worked.  For whatever reason the field of AMS tracking is not an option to choose in the Filters.  Trying to figure out how to get it to BE an option.  Any more ideas?

Sandy

[Mathew Lederman]

@Sandy Helmer do you know if it's a regular custom field? Or perhaps a calculated value that's not a true field on it's own?

[Sandy Helmer]

@Mathew Lederman its an available field to ADD to the "Context Field" from a drop down picker.