iSPCChart Histogram X-Axis limits

Hello

I would create a histogram chart (iSPCChart) with 7 bars.

X-Axis should start from 0 and each bar should have width 10.

How can I specify this in an iSPCChart object?

I found the parameters for number of bars, but I can't find the start of X-Axis and the bar widths.

Note: the begin of X-Axis is very important for me (it represents time, then negative value is an error), bar size would be desirable.

Thank you a lot

Best regards

Fabio

MII 12.2 sp5

SAP Managed Tags:
SAP Manufacturing Integration and Intelligence

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi Fabio,

We are running into a similar issue with X-Axis scales on a Histogram. Were you able to resolve the above issue ?

Appreciate any input on this topic.

Girish

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Fabio & Girish,

There are two issues on the histogram chart being discussed here.

1. Negative values in the histogram chart-

As you know, Histogram chart counts the no. of records against the distinct values and provides the output as a bars with count of the records for those values.

This is the expected functionality out of the chart and it is working as expected in your case. All you need to do is validate the values as per the process requirements and remove the invalid values at transaction or query level.

Also striking a process orientation through established SoP(Standard operating procedures) wil ensure such invalid value wont occur any more.

2. Bar width can be fixed using the Histogram Cell Count parameter in the Parameters tab of the iSPCChart configuration.

So by adjusting the width of the chart at HTML applet parameters and the histogram cell count parameter using the java script function "iSPCChart.getChartObject.setHistogramCellCount(int)', you can set the bar width.

With regards,

Ponilango

Hello

About point 1: I already implemented the filter (just values >0 and <=70), but the MII logic starts from negative value. If you want to make a test, at the end of this post you will find XML with my data: I use the column "Total".

About point 2: I already used HistogramCellCount, but it fixes just the number of bars. I would have 7 bars between 1 and 70, then each bar should represent the value for a range of 10 (1-10; 11-20; 21-30;...). The behavior of the graph is different.

Thank you

Best regards

Fabio

Below my data

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

</Columns>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

</Rowset>

<Message>Unable To Create Stylesheet Transformation</Message>

</Messages>

</Rowsets>

Thanks for both of your responses. See the Histogram Below.

If you look at the X-Axis values - you will notice that the values are - 0.9132, 0.9134, 0.9135. 0.9136, 0.9138, 0.9140, 0.9142, 0.9145, 0.9146, 0.9147, 0.9149.

Values on X-Axis (so called bins) are not uniformly distibuted .. some time it is 1/100th of difference and some times it is 2/100th .. If you plot the histogram with same value set in any other statistical software such as Minitab, you will see that the bins are unformly distributed (in Minitab you will see that the bin is 2/100th difference).

Histogram cell count influcnces the no of bars .. is there anyway you could influence how the bins are calculated so that they are unformly distributed.

I have raised a tickect to SAP OSS as well .. we are on MII 14.0 SP 4 Patch 1.

Any thoughts ?

Hello Fabio & Girish,

Your problems (both are almost the same) are much clearly depicted, thanks for that.

I have to concede that the iSPC Chart of Type Histogram, is not having any direct parameters to achieve what you both are trying to do. (At least up to my knowledge)

But implementing some flexible transaction logic to group your values into your desired ranges will certainly help you produce the desired result.

I have taken the sample XML provided by you (Fabio) and applied a simple logic to get your values grouped in the desired range.

Please find the Transaction which follows the simple logical sequence,

Repeat over your 'Total' values
Using the combination of modulo and division operators based logic below against a flexible range limit value (From the sample 10 as Local.RangeLimit)
Row.Range =

if(number(Repeater.Output{/Row/Total})%Local.RangeLimit>0,

floor(number(Repeater.Output{/Row/Total})/Local.RangeLimit)+1,

floor(number(Repeater.Output{/Row/Total})/Local.RangeLimit)+0)

4. Range 1 means your Total value is lying between 1-10, Range 2 means 11-20 and so on.

5. Construct a new MII XML Doc with these values included as a new column –Range

6. When using Range as the value column in the SPC Chart of type Histogram with Histogram Cell count (8=>7+1) I get the chart output as captured below.

In case of you (Girish) try changing the RangeLimit value to 0.001 or 0.002 to group your values and assign a suitable range (0.9136-0.9138) for your display column.

Hope this helps, if you want the transaction and chart files – send me a direct message I’ll try to send it across.

With regards,

Poni

Hi Poni,

Interesting approach .. I will try with our anaylsts (but I do not think they will go for it). The values are product dimensions and this chart is produced as the operator is entering the dimensional data for the product. Operator reviews this chart, looks at the dimensional trend and then adjusts the machine .. we plan to us Histogram and XBAR-MR chart in combination. XBAR-MR chart in MII is very good .. behaves very close to a minitab chart.

I have opened a ticket to SAP and waiting to hear from them. The other thing I noticed is, when you right click on the Histogram and select the SPC results, Cp, Cpk values etc show up as 'NA' which does not make any sense. Even the standard deviation is display as zero.

In any case, can you send me the files to .. 'ghegde@gtweed.com'.

Thanks,

Girish

Hello Ponilango

This idea could be implemented directly in SQL query, using "/10" in selected column.

The result is the same.

But in this way, the user loses the direct conversion between image and logic.

For example, if range is 5 and column X value is 16 to 17...real range is...boh: he needs a calculator.

For this reason, I cannot use this method.

Thank you

Best regards

Fabio

Dear Fabio & Girish,

Excuse my delay.

Fabio,

I just worked out on your given data sample - so the transaction, MII allows you to place to your logic in your Query, Transaction, XSL or in your JavaScript.

To make the output more readable I can just multiply "Local.RangeLimit" by the Calculated "Range" column from the above mentioned expression.

Another complex development that you could use to derive your required output may be to,

1. Generate your SPC values out of a custom transaction employing MII's SPC Action blocks

2. Custom chart with bar and line chart for displaying the values.

I agree with your thought (out of my personal experience) - MII SPCCharts are not completely equipped when compared to Minitab & other SPC tools. But that's were MII's development tools comes to your aid like above.

When you want such specific requests to be addressed by SAP tech support, the usual reply you get will be a re-direct to their consulting department.

Who will consult you with a similar walk through using possible MII work-arounds. Good luck with that.

With regards,

Ponilango P

Ask a Question

Top Q&A Solution Author

User

Count