In reports, can you create dynamic annotation from fields that aren’t in that report dimension?
Example: I have a stacked bar chart where the Y-axis shows invoices (sum $) and the X-axis shows invoice date.
My entities also have a lookup for what the team budget is on the invoice date.
I want to create an annotation line on top of the stacked bar chart that shows where the budget is. See sketch below. But the dynamic annotation options for this Y-axis, seem to only allow using the invoice $ field, rather than being able to pull a new field (from the available data fields) to layer on top.