Do you want to know what the visual can do? Or interested in licenses?
See Control Charts Product page.
See our help videos on Youtube.
1) Add measured value
This must be numeric data. Usually, it is some measurement or KPI that you are interested in, such as lead time, weight, or size of the component.
2) Add X
Control charts plot measure by time, so you have to add some time measure. It can be a date/time but also a number. It is important that X has a distinct value for each measurement, and that’s it is in the correct order. If your data is not in the correct order, the control chart will yield incorrect results.
If you don’t want to use the same variable for identification and ordering of data rows, use Row Id in combination with X. When using Row Id, x is used as a label, so each value of x need not to be unique.
For p- and u-charts you also have to Area of Opportunity.
3) Select chart type (only in full version)
4) Optional: add other data roles
You can also add row id, subgroup, and tooltip.
Row id can be used with datarole X when it doesn’t identify and order datapoint correctly. In this case, the X is used as a label in the axis, but row id is used in calculations.
The subgroup can be used to 1) indicate change points, and 2) in S-Chart to dynamic subgrouping + indication change points. S-charts can use two data roles in subgroup role. Other charts use only one.
Tooltips can use multiple data roles.
PowerBI framework loves to aggregate data. This means that duplicate values are transferred to visual only once. Usually, this is the right thing to do, as many times it doesn’t make a difference for visualization. Aggregating data has a positive effect on performance.
When using Control Charts, aggerating has to be done in the visual, in order to get correct results. That’s why it is mandatory that data comes to the visual in the correct order and correct granularity. Best way to achieve this is to use Row Id.
Create a visual, fix the needed settings and add the license key. Copy this visual when creating actual visualization. For the copies, you don’t need to add license key separately. You can even create an additional page to the report and place the original visual there. Remove the extra page when the report is ready.
See the help video on how to enter the license key, and how to copy the visual, so you don’t have to enter the key again.
If you have a larger data set than a few thousand items, you will be better off using Power BI Desktop or Chrome browser.
You should also make sure that you have selected the ‘Draw > Mode > Dynamic’ option from the settings.
It is faster to create a report if you filter the dataset to contain fewer elements and remove this filter when the report is ready.
Please check your chart type. P and u-charts require that you add an Area of Opportunity.
There are two ways to get the visual:
1) AppSource website
You can download the visual file and example report from the AppSource website. After downloading the visual file, select “Import from file” in Power BI desktop and select the downloaded file.
2) Import directly to report
Use the Power BI’s “Import from Marketplace” feature and add the visual directly to your report.
We are more than happy to hear from you. Send mail to support (at-the) craydec.com.
1.1.0 / 22.4.2019
- Setting grouping clearer
- Tooltips, selections & run tests to free version
- Custom sized data-area
- User option: failed run test color
- User option: x-axis label rotation
- User option: value label for UCL/LCL, CL
- User option: x/y label tick size
- User option: facet label on/off
- User option: facet common y-axis on/off
- Fix: X-axis label overlapping
- Fix: failed run test indicator position
- Fix: data point without value caused a crash
- Fix: data points rects IE/Edge
- Fix: data points selection to point middle
1.0.0 / 2.4.2019
- Initial version.