Return Last Item from a Table
I have a table with a set of numbers and dates. I'm only interested in the last number / date item in the results returned by a query. Any idea how I can get that single value out of the table and into a report through Report Studio? For example there is a list of numbers starting at 0 ending at 99. I only want to display the number 99 on a graph.
Thanks in advance. Derry |
3 answers
Hey Derry,
You can try the "maximum" function in the report studio to create a measured data item and plot that on the graph. |
Hey Derry, Thanks Hardik. That works but it has to be on a filter. And you set the value to 1. |
|
What we did to get a single value from a list was to set a filter on one of the incoming data items. It was a date type so we filter on the 'maximum' date value which gives the latest date. YMMV on other data types. Does any know if there is a function to retrieve an item based on index or some other attribute?
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.