Using Text in chart to display last data point on line chart
I am trying to display the last data point value from my line chart to a text in chart. But I do not know how to reference the last data point in the text in chart expressive. My dimension is [Date] and my expressive is [MV], where [MV] is "=if([Date]=vStartDate,($(vAmt))*(1+[Return]),(above([MV])*(1+[Return])))"
I don't think set analysis work with the above function. I try using the below expressive with no luck:
[MV] is the label for my vMV expressive column, I don't need to sum. I just need to somehow reference the value of [MV] where Date=max(date)
Depending on your data model and requirements, something like this could work or maybe won't work. It would be helpful if you explain your other fields and the variable $(vAmt) a bit more. At best, you could attach a small sample app to your posting that demonstrate your issue.