メイン コンテンツにスキップ

Control Chart

Nova Silva BV

4.3 (3)

The most useful way to see true signals of change in your KPI is to use a ControlChart (XmR chart)

The ControlChart chart is actually two charts. The X is the data point being measured and mR the Moving Range which is the difference between consecutive data point measurements.

The upper chart (X-Chart) displays the data-points over time (Actuals) together with a calculated average (Average - center-line (CL)). The calculated average is then used to calculate the Upper and Lower Control Limits. The lower chart displays the Moving Range (mR-Chart) with its Average and Upper Control Limit. There is no lower control limit as the value of the difference between consecutive actual-values is recorded as an Absolute Value (positive number).

In this custom visual you can hide the lower chart (mR-Chart).

The calculation of the charts can set to Automatic in this visual. The rules being used for the automatic recalculation are:

- 7 points in a row are above or below the center-line

- 10 out of 12 points are above or below the center-line

- 3 out of 4 points are closer to the UCL or LCL than the center-line

You also can add a data-value that enables manual calculation. The charts will be recalculated at the date-value where the value is set to 1.

アドインの機能
このアドインを使用すると次のことが可能です:
  • ドキュメントの読み取りと変更を行うことができます
  • インターネット経由でデータを送信できます
  • https://store-images.s-microsoft.com/image/apps.36885.36cd7e08-4721-412b-ace1-2a53567bfdb0.8402c476-450b-4146-bcd5-ce704299408b.7194f00e-3bae-46e1-960c-065b4ded548b.png
    https://store-images.s-microsoft.com/image/apps.36885.36cd7e08-4721-412b-ace1-2a53567bfdb0.8402c476-450b-4146-bcd5-ce704299408b.7194f00e-3bae-46e1-960c-065b4ded548b.png
    https://store-images.s-microsoft.com/image/apps.60342.36cd7e08-4721-412b-ace1-2a53567bfdb0.8402c476-450b-4146-bcd5-ce704299408b.32b4a4ed-e35a-4b6d-92db-1f9e938db068.png
    https://store-images.s-microsoft.com/image/apps.41093.36cd7e08-4721-412b-ace1-2a53567bfdb0.8402c476-450b-4146-bcd5-ce704299408b.cb5a81fa-2f18-45f7-864b-993fcb23af6a.png
    https://store-images.s-microsoft.com/image/apps.41171.36cd7e08-4721-412b-ace1-2a53567bfdb0.8402c476-450b-4146-bcd5-ce704299408b.b72d58c6-372b-4b8d-8020-30ab62f4c85f.png