Hello. I have the following custom fields which I’d like to visualize in a bar chart by Quarter-Year:
- Qtr End (Target)
- Qtr End (Actual)
When trying to use “Time” dimension by ‘Quarter-Year’, I run into issues because this is using the issue created date which may not be in the same Qtr End. (e.g. issue was created in November 2018 but Qtr End (Target) = Q1 2019 and Qtr End (Actual) = Q1 2019. This causes my chart to not report metrics accurately.
My question is: Is there a way to create a new date field that I could apply to my horizontal axis which matches the value set in Qtr End (Target) & Qtr End (Actual)? This should then allow for me to graph a distinct count of issues for Qtr End (Target) & Qtr End (Actual), respectively, where this new custom field is the common key.