Pull the "Current" item using GETAT


Author
Message
Bob Smith
Bob Smith
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
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...

Reply
Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

You currently use a step line chart with sub type of “Series” and you have a categorical scale.
In order to format the X axis as you require, you can use an expression to format the category labels. Under Pivot >> Data Groupings >> Categories >> General
For the Label field you can use: =FORMAT(Fields!Date, "MMM", "en-US")

However, you have multiple data points for one month and the result for the X axis will be:
Jan Feb Feb Feb Mar etc.

In this case you should be using an XY Scatter sub type and the Numeric scale. When you switch to XY Scatter sub-type, under the Pivot tab you first need to provide an X value (=Fields!Date).

Then from the Chart >> Chart Areas >> Axes >> Primary X >> Scale tab >> Numeric, you can configure the formatting:
Sub Type: Date Time
Formatting Mode: Fixed
Label Format: MMM

and set the Step Mode to custom step – 1 Month.



Best Regards,
Nevron Support Team


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search