Edit Properties within a Chart

[Iowabeef]

Good morning all,

Guess who's trying to learn more by working through a new report setup...

Setup:
Bar Chart is setup, populates and works ...mostly fine
I have a Query (report_type) that returns either '500_and_Over', OR 'Under_500'
I have a param (overorunder500_var) that is linked to this Query
When you launch the report, you can select either 500+ or Under 500, and the chart is populated (side Thank You to Member Deanicus for their help here the other day)

Issue:
Within the Bar Chart itself, under the available options is y-scale-factor, y-tick-interval, etc... I would LIKE when '500_and_Over' is selected, these properties will set to 1000.0 and 1000.0. And when selecting 'Under_500', properties would be scale=500.0 and interval = 100.0

What I can and cannot do:
For this particular Chart Property(s), when selecting the Edit Property, does NOT contain a "formula wizard" ... that's fine, I can write a C#\C++ line in VS and make it work, BUT I apparently cannot write one in PRD freehand ... spent most of yesterday trying different formula configurations, but no luck. There is an 'OK' button on the Edit Properties box that no matter what I try, just will NOT activate so I can click it... 'Cancel' is my only option.

Questions:
This is mostly what I have been trying in the y-scale-factor properties... =IF([overorunder500_var]="500_and_over"; "1000.0" ; "500.0" ; ) ((many iterations... just not the right one yet))
What am I doing wrong (Nice question huh.)
Am I trying to read off a param that I cannot "see" from within the Chart?
Do I need to select a different variable or add a query or select a different field\choice before the Edit Properties box will see I have an If\Else statement in there?

Thanks in advance for any assistance
Iowabeef

[Iowabeef]

Apparently, from what I have found reading Pentaho documentation and scouring the web for any workarounds...

You cannot make line item edits to ANY FIELD that does not contain a "formula wizard" within the Edit Property.

BUT, you can learn beanshell, and write a Chart Post-Processing Script:

import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.axis.ValueAxis;
import java.util.*;
import java.math.*;
import java.util.List;
import java.util.ArrayList;


CategoryPlot chartPlot = chart.getCategoryPlot();
ValueAxis yAxis= chartPlot.getRangeAxis();
data = chartPlot.getDataset();
keys = data.getRowKeys();
ArrayList dataVals = new ArrayList();
for (int i=0;i<keys.size();i++)
{
ab=data.getValue(i,i);
dataVals.add(ab);
}
Double maxVale=(Collections.max(dataVals)).doubleValue();
Double minVale=(Collections.min(dataVals)).doubleValue();
yAxis.setUpperBound(maxVale+5);
yAxis.setLowerBound(minVale-5);

and insert all that information into your Chart Properties:



And while it isn't exactly what I was looking for, it IS a workaround.

And now you know too.
Iowabeef