Using a line series to create a Paredo chart

1 Answer 39 Views
Expressions Graph Report Designer (standalone)
Steve
Top achievements
Rank 1
Iron
Steve asked on 02 Aug 2023, 03:15 PM

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

1 Answer, 1 is accepted

Sort by
0
Momchil
Telerik team
answered on 07 Aug 2023, 11:36 AM

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

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Steve
Top achievements
Rank 1
Iron
commented on 07 Aug 2023, 01:14 PM

Thank you so much!!!
Tags
Expressions Graph Report Designer (standalone)
Asked by
Steve
Top achievements
Rank 1
Iron
Answers by
Momchil
Telerik team
Share this question
or