I'm trying to create a line chart (basically the graphs on sheet 2 of the attached excel file). As you cans see in the pivot table I am trying to look at the number of occurances (y-axis) where the rate of production is between intervals like 0-10%, 10-20% and so on... Does my expression have to be wrriten using RangeCount or am I just totally off track here? I attached what I have so far.
(how do I write an expression that says how many # of occurances occurs in a data set range(from 0%-500%, with 10% intervals by example)