Using a line series to create a Paredo chart

[Steve]

I have a chart with a bar series and a line series, where I would like the line series to form a cumulative % of the total.

My data set is a list of records with an "Injury Type" field, and the bar series counts the instances of each injury type

The line series is a calculation of the count of instances of that type divided by the total count of the graph.

What I would like instead, is to have a cumulative % of the line so that at the end it would = 100% like a Paredo chart would

Screenshot attached

[Momchil]

Hi Steve,

I believe that what you described can be achieved using the RunningValue data function. For example, the X value of the line series can take the expression below.

= 1 + (Count(Fields.RecordID) - RunningValue("Injury Type", Sum(Fields.RecordID Is Null ? 0 : 1))) / CDbl(Exec("Injury Type", Count(Fields.RecordID)))

Which yields the following result on my end.

For your convenience, I am attaching the report I used to test the expression.

I hope this helps.

Best Regards,
Momchil
Progress Telerik

[Steve]

Thank you so much!!!