How to resolve an IQC chart in Spotfire Statistica that is not displaying data according to the calculated variable in the Analysis Configuration

How to resolve an IQC chart in Spotfire Statistica that is not displaying data according to the calculated variable in the Analysis Configuration

book

Article ID: KB0135702

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.0.1 and Higher

Description

This can be observed after adding the calculated variables and building the chart. While the chart runs without error, in some cases, only the calculated variable charts are required, allowing us to turn off the old charts. However, after doing so, we may observe that the new chart does not pull any data.

 
image.png

Environment

Windows Server and Windows 10

Resolution

Resolution 1 :

One cause of this issue is that the data type of the variable we want to turn off is set to 'Text'. When we designate this as a 'Variable Characteristic', Statistica interprets these values as numeric. Consequently, when the calculated variable chart is generated, the variable formula can round this numeric value and include it as valid numeric data for the calculated variable.

However, when we set this data type back to "Data," Statistica no longer interprets the column as numeric and instead treats it as text.

image.png

This can be confirmed by examining the variable type of the XYZ variable in the spreadsheet when running the analysis configuration. Since the calculation is now performed on text data, attempting to round a text value results in blank values.

image.png


To resolve this, set the 'Variable Type' option to 'Double'. This will change the original column's variable type to double in the spreadsheet, allowing the calculation to be performed correctly.

image.png

Calculated Variable:

image.png

The analysis now show the Calculated Variable values and generated the chart as expected:

image.png

Resolution 2:

The other option would be to just turn the graph off for the graph you don't want to see in the analysis anymore.
For example, the settings below will turn off the XBar & R Chart for the "Work" variable and leave only the calculated chart in its place. 

image.png

Issue/Introduction

This article gives workaround when calculated variable chart of IQC analysis does not consider the configurations set for it and follows the main variable configurations.