How to find the number of samples in each Data Entry Setup?
Article ID: KB0078685
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and higher |
Description
TIBCO Statistica may have multiple data entry setups and each data entry setup may have multiple samples. How can one quickly look up how many samples are entered for every data entry setup in TIBCO Statistica?
Issue/Introduction
TIBCO Statistica may have multiple data entry setups and each data entry setup may have multiple samples. How can one quickly look up how many samples are entered for every data entry setup in TIBCO Statistica?
Resolution
The following query can be executed against the Statistica meta database to find out how many samples are there in every Data entry Setup :
Select Count(SAMPID) as sample_Count,CSPROF.NAME from CSSAMP left outer join CSPROF on CSSAMP.PROFID = CSPROF.PROFID group by CSPROF.NAME;
Select Count(SAMPID) as sample_Count,CSPROF.NAME from CSSAMP left outer join CSPROF on CSSAMP.PROFID = CSPROF.PROFID group by CSPROF.NAME;
Feedback
Yes
No
Powered by
