The best would be for you to post a packaged workbook instead of the extract to show exactly what you're tying to achieve.
But to make sure I understand, you want to show the progression of that KPI over time on a graph and then only have a label for the last value available is that it?
If that's the case, a calculated field could work. A calculation using DATEDIFF() and TODAY() and showing NULL if the values match.
Something like IF DATEDIFF('day',TODAY(),[Date])=0 THEN [Value] ELSE NULL END
Or do you want to only show a single numerical value for the last available day?
I updated the attachment with a .twbx file.
I am trying to be able to let the user show however many days previous they want, based on the Parameter # Last X Days.
On top of the line graph, I would like only the previous day to show the indicator shape.
Thank you for your help!
So I don't know if this is what you're trying to achieve but here's what I did: (see attached workbook)
I modified your Service Level Color calculated field for this:
(IF [SL%] >= .85 then 'Green'
ELSEIF [SL%] >= .75 then 'Yellow'
ELSEIF [SL%] < .75 then 'Red'
It's checking for the last value on the graph and then it shows the indicator if it is and gives it the color white if it's not.
I thin changed the shapes and colors for the "White" value.
I also created a new calculated field "Service Level Size" with the following formula:
IF [Service Level Color]="White" THEN "Small" ELSE "Regular" END
And then dragged that to the size section and assigned a small size to the "White" value.
Book3.twbx 20.9 MB
I think this is going to work!
Thank you so much. I appreciate your time!