1 of 1 people found this helpful
It would seem that an annotation (right click a blank area on the chart) cannot take a calculation as an argument. However, a title can, or you can create a dashboard with a separate sheet with the text in it. The calculation would be something like
""Tickets are "& (if [current value]<[prior value] then "down " else "up " end)& str(abs(1-[current value]/[prior value])*100) & "% compared to the same period last year"
Where [current value] and [prior value] are other calculations you have created. I wrote this off the top of my head, so it likely will have an error or two.
Sorry for the late reply
Thanks for confirming Alex,this is what i have already used as not find a dynamic comment object.
at the same is there any way to add HTML in this dynamic comment.(in calculation Dimensions)
i want to add shape like Tick mark or cone shape or anyother shape from the starting of the comment