Products | Versions |
---|---|
Spotfire Statistica | 14.0.1 and Higher |
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.
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.
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.
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.
Calculated Variable:
The analysis now show the Calculated Variable values and generated the chart as expected:
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.