I hope this message finds you all well.
I'm struggling with an idea I had at lunch today. I'm hoping someone out there has had the same idea!
Here's what I'm after:
I'm trying to add dynamic annotations on my viz. These annotations will be driven based off my Current Date parameter.
I would like to add QoQ and YoY dynamic percentage change annotations. On the attached, I have created a QoQ% change calculated field and a YoY% change calculated field, however there must be an error since they do not work when I drag them out to my viz
Below is a mock-up of what I want-> an annotation for the QoQ change and an annotation for the YoY change. These need to be dynamic so when I add more quarters to the view, my annotations automatically update.
Let me know what you think.