AUS-DOH-Safety-and-Quality / PowerBI-SPC

A free and open-source PowerBI custom visual for SPC charts
GNU General Public License v3.0
44 stars 15 forks source link

Add function to extend baseline from specific, or relative data point #298

Open bsre01 opened 5 months ago

bsre01 commented 5 months ago

Currently the 'Target' mean line is calculated from all points within the visual, however for testing for improvement against previous performance it would be more useful if we could select which data points were baseline data and only use those for calculating the mean. This could be through a relative data points option (i.e - use first x points as baseline), or a specific selection (end baseline at date x).

As an added bonus, if it was possible to set the format of the target line before and after this point independently that would be the cherry on top - i.e having it a solid line throughout the baseline period and dashed after it is extended.

bsre01 commented 5 months ago

This could also be sort of achieved by letting us choose which target line is used for outlier highlighting rules. Since we can set a custom value for the Alt. Target, if we could also use the Alt. Target as the calculating mean for shifts, limits etc, we could effectively use a value we have calculated from previous performance for this line, hide the original line and have an 'extended' mean this way.

The more direct way above would be better, but if this is an easier option it would do the job fairly well.

carolineb936 commented 3 months ago

Agree we would like this