Investigate the Data

4.05.00 FactoryTalk Data Explorer User Guide

Data Explorer Overview

Data Preparation

Transforms

Status

Date/Time Reference

Export ML Transform (ETL) Manifest

Virtual Online Analyzer® Modeling

Install Data Explorer and Import Data

Prerequisites

Install Data Explorer

Launch Data Explorer

Import Data Files

Navigating Data Explorer

Manifest

Artifact Tabs

Tool Bar

Configure Custom Properties

Reorder Columns

Menu Bar

Project

Edit

View

Dataset and Spreadsheet

Saving and Opening Projects

Windowing on Tabs

Investigate the Data

Plotting Data

Trend Plots

Overlay Plots

XY Plots

Carousel Plots

Raw vs Transform Plots

Y Axis Configuration

Plot Tool Bar

Plot Example

Cutting Data

Highlighting Data

Filtering Data

Analyze Data

Histogram

Correlation

Ranked Correlation

Delay Correlation

Statistics

Merge Data by Time

When Time Merging Is Required

Time Interval and Time Delays

Preparing the Dataset for Time Merge

Time Merge Variables

Certainty

Performing a Time Merge

Manage Transformed Data

Transform Calculator

Transform Order

Transforming Data

Adding Transforms Graphically

Editing the Transform List

General Transform Syntax

Transforms With Multiple Outputs

Entering Multiple Transforms Simultaneously

Column Length of Independent Variables

Arithmetic Operators

Relational Operators

Conditional Expression Constructors

Miscellaneous Buttons

Export and Model Data

Exporting Data

Export Delay ID

Calculator Export

Export Files

Export Data

Export Calculator

Model Data

Model Definition Tab

Artificial Neural Network Example

Expression Model Example

Delay ID Tab

Training Tab

Analysis Tab

Overriding Nominals on Analysis Plots

Calculator Export Tab

Lab Bias Tab

General Model Recommendations

Transform Reference

General Information and Conventions

Breaks

Moving Window Transforms

Transform Combination Restrictions

Common Transforms and Constants

abs(x)

acos(x)

acosd(x)

arx(var, D, b0, b1, …, bN-1, a1, a2, …, aN, mode)

ascend

asin(x)

asind(x)

atan(x) or atan(y,x)

atand(x) or atand(y,x)

average(var,size[,alignment[,threshold]])

biasSensor(var,lab,tolerance,filter[,lab_delay],max_delay)

break(x)

center

certainty(var) )

changedate($self,dtVar) or changedate($self,$none)

changestat($self,startrow,[endrow,]status)

char(int[,int[,int…]])

checkFlatline(var,tolerance,window)

checkRange(var,min,max)

checkRate(var,tolerance)

clearRows($self,startrow[,endrow])

clipabove, clipbelow

compare(string1,string2[,codes])

copyBreaks(var)

copyRows

corr(var1,var2[,count])

correlation(var1,var2,…,varN)

cos(x)

cos(x)

covariance(var1,var2,…,varN)

covarTD(numX,numY,x1,t1,x2,t2,…,xN,tN,y1,s1,y2,s2,…,yM, sM)

cutabove, cutbelow

cutstat(value)

day(dtVal)

deleterows($self,startrow[,endrow])

delta(var[,n])

descend

differs(var)

double(x)

dt(dtVal)

dtadd(dtVal,increment)

dtcreate(dtStart,dtEnd,increment)

dtdiff(dtVal1,dtVal2)

dtmake(year[,month[,day[,hour[,minute[,second[,millisecon ds]]]]]])

dtread(string[,format])

dtround(dtVal,increment)

dtwrite(dtVal[,format])

dup(string,n)

duprows($self,startrow,endrow)

dwt(var,direction)

e

encode(var,proximity,type,value1[,value2,…valueN])

error

etread(string,format)

etwrite(x,format)

exp(x)

expave(var, ff [, mode])

fft(var,length)

filter_freeze

filter_disable, filter_smooth

findle(var,a1,a2,[b1,b2,[c1,c2,…]]z)

fmt(x,format)

forcestat(x,status)

forward

heartBeat(var,N)

HistFreq(string)

HistStr(string)

holdLast(var [,num_cycles])

hour(dtVal)

if(expression,trueValue,falseValue)

iifft(realVar,imagVar,length)

inf

insertrows($self,startrow[,numberOfRows])

int(x)

inverse

isBadStatus(var)

isbreak(var)

isvalid(var[,var2,…,varn])

join(var1,var2[,var3,…])

lag

lead

left(x,n) or left(x,characterList)

len(string)

ln(x)

log(x[,y])

lookup(var1,var2)

lookupRel(var1,var2)

LowFreq(stringVar,N

markcut

max(x)

max(x,y[,z,…])

mean(var)

median(var)

member(stringVar1, stringVar2)

mid(string,numstart,numend)

midn(string,length,numStart)

millisec(dtVal)

min(x)

min(x,y[,z,…])

minute(dtVal)

x mod y

month(dtVal)

moveave(var,size[,alignment[,threshold]])

moveexp(var,size[,alignment[,decayRate[,threshold]]])

movegauss(var,size[,alignment[,stddev[,threshold]]])

movels(var,size[,alignment[,threshold]])

movemax(var,size[,alignment[,threshold]])

movemed(var,size[,alignment[,threshold]])

movemeda(var,size[,alignment[,threshold]])

movemin(var,size[,alignment[,threshold]])

movesd(var,size[,alignment[,threshold]])

movevalid(var,size[,alignment])

none

now

nrows(var)

nvalid(var)

ord(string)

override($self,startrow,[endrow,]value)

pca(var1,var2,…,varN)

pi

pos(character,string)

preserveRow(var,row)

prev, prev2

rand, random, randomS, randS

rank(var)

real(x)

right(x,n) or right(x,characterList)

round(x[,y])

row (No arguments.)

scale(var[,a,b])

scatcut(Yvar-self,[Ylow,Yhigh,]Xvar,Xlow,Xhigh,startrow,en drow)

second(dtVal)

self

setcert($self,certaintyvar)

shift(var,n)

sigmoid(x[,a[,b]])

sign(x)

sin(x)

sind(x)

sort(var1,var2[,direction])

sqrt(x)

status(var)

stdev(var)

str(x1[,x2[,x3,…]])

strcode(stringVar,value1[,…,valueN])

subcol(var,startrow[,stoprow[,increment]])

subst(stringVar,pattern,replacement[,'u'])

sum(var)

tan(x)

tand(x)

timecut

timemerge

tm_average, tm_boxcar, etc. (All keywords beginning with tm_)

tmerge(valueVar-self,dtVar,method,interval,maxTimeGap, handleDuplicates, handleOutOfOrder,maxCert)

today

trend(var)

trunc(x)

ttv(var)

unmarkcut($self,startrow,endrow,low,high)

unscatcut(Yvar-self,Ylow,Yhigh,Xvar,Xlow,Xhigh,startrow, endrow)

untimecut($self,dtVal1,dtVal2,low,high)

val(string)

valid(var1[, var2, …, varn])

weekday(dtVal)

withinPct(x,y,z)

year(dtVal)

yearday(dtVal)

Random Number Transforms

Gaussian Random

System-Generated Transforms

Applied from the Time Merge Window

Applied from Plots

Transform Finder

Date/Time

Editing

Filtering/Smoothing

Math and Statistics

Miscellaneous

Signal Processing

Status

Strings

Type Conversion

Type Forcing

Troubleshooting

Investigate the Data

This chapter walks you through cleaning up, transforming, and filtering your imported data.

Highlighting Data

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.

Normal