Profile Picture

Pull the "Current" item using GETAT

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1
I would like to use additional information about the "current" item in the data labels a line chart.

Here is some "sample" data:

DateTotalAction_Type
1/1/1310Restock
1/2/135Sale


I.E. I have a series of points in a step line chart. Each point represents a value and a date. On 1/1/13 "total" is equal to 10. On 1/2/13 "total" is equal to 5.

I can use the <value> data point to place the current value in a label on the data point.

I'd like to add the "Action" value to the data label so that the change in the "Total" between 1/1 and 1/2 is explained on the chart.

I can place "Fields!Action_Type" into the data label, but because I am referencing an array it only places "Restock" in the data label. I.E. Both instances on the step line chart will state "Restock" despite the fact that the change in inventory was due to a sale.

Is there some way to use the GETAT(arr, index) function and place the current "index" value into the index field in order to extract the action type of the current item?

It might look something like this:

="<value><br/>" + GETAT(Fields!Action_Type, CurrentItem)

Hypothetically this would return the following data labels:

10
Restock

5
Sale

I hope this question makes sense...





Similar Topics


Reading This Topic