Is there an easy way to add the value of the right-most point of a time-series graph? This would make it easy to identify what the value is exactly.I don't want every point on the graph labeled, though.
The expression for my trend graph looks like this:
Dimension is Month.
Thanks for the example. I've tried using your expression
if(Month='$(=Max(Month))', Num(Avg(Perc), '0.0%'), ''),
and replacing "Ave(Perc)" with my function, but had no luck.
It is not really to do with luck.
Make sure that you have no format (expression default) specified in the number tab. you have "Value on data point" specified.
Of course, I have no clue as to what is the problem because I don't have your data and "I had no luck" isn't really a great problem description.
Stephen, your advice has certainly increased my luck. I can now get the value of the final point to be displayed at the bottom of the graph, at least. I did this by also checking "Text on Axis" as a Display Option on the Expressions tab.When I uncheck this box, the value disappears. I appreciate your help on this problem.
If you copy my chart into your document and modify the dimension and expression, does it work?
Do you have multiple dimensions or multiple expressions to achieve the 3 lines?
The problem is occuring when I add more than one expression to the graph. It can't seem to handle more than 1. When there are 2, they both work when only one is enabled. But, when both are enabled, the % disappears. The trend line still shows.