Datagration Knowledge Base
English
Deutsch
Sign in
Deutsch
P#
Getting Started
Introduction to PetroVisor
Data Model
PetroVisor Apps
General Functions
Analyze
Home
Dashboards
Maps
Data
Data Grids
Predict
Decline Curve Analysis (DCA)
Machine Learning (ML)
Scenarios
Build
Develop
Library
Workflows
Tables
Logs
R
Data Model
Entities
Signals
Hierarchy
Sources - Connections
Sources
Settings Bar
User Settings
Workspace
Cloud Admin
P#
Getting Started with P#
Data Cleansing
String Functions
Scenario Functions
Regression Functions
Placeholder Functions
Neighborhood Functions
Mathematical Functions
Logic Functions
Entities Function
Moving Window Functions
Time and Date Functions
Statistical Functions
Economic Functions
Data Handling
Additional Functions
Directional Functions
Machine Learning Functions
Voronoi
DCA Functions
Updates
2022
2021
Back to home
Datagration Knowledge Base
P#
Getting Started
Introduction to PetroVisor
Data Model
PetroVisor Apps
General Functions
Analyze
Home
Dashboards
Maps
Data
Data Grids
Predict
Decline Curve Analysis (DCA)
Machine Learning (ML)
Scenarios
Build
Develop
Library
Workflows
Tables
Logs
R
Data Model
Entities
Signals
Hierarchy
Sources - Connections
Sources
Settings Bar
User Settings
Workspace
Cloud Admin
P#
Getting Started with P#
Data Cleansing
String Functions
Scenario Functions
Regression Functions
Placeholder Functions
Neighborhood Functions
Mathematical Functions
Logic Functions
Entities Function
Moving Window Functions
Time and Date Functions
Statistical Functions
Economic Functions
Data Handling
Additional Functions
Directional Functions
Machine Learning Functions
Voronoi
DCA Functions
Updates
2022
2021
P#
Introduction to P#, Datagration's unique petro-technical scripting language.
Getting Started with P#
What is the autocomplete in P# scripts?
What is P#?
What are the PetroVisor Scripting Best Practices?
How do I write P# Scripts?
How do I make sure that no one can edit my P# script?
How do I use Placeholders in P# Scripts?
How do I know what's being changed on my scripts?
See more
Data Cleansing
How do I write a data Cleansing Script in P#?
What is data cleansing in PetroVisor?
String Functions
Signal()
NullString()
Concat()
CurrentEntity()
CurrentParent()
ParseJSON()
ToString()
See more
Scenario Functions
ScenarioEntities()
ScenarioScope()
ScenarioValue()
Regression Functions
RegressionParameters()
RegressionValue()
Placeholder Functions
_DateTime()
_Double()
_Entity()
_Integer()
_Signal()
_String()
See more
Neighborhood Functions
AggregateFromEntitites
AggregateGrid
AggregateIf
AggregateIfTagged
AggregateNeighbors
AggregateSiblings
AggregateVoronoiCells
CountChildrenByTag
Neighbors
PercentRank
See more
Mathematical Functions
Aggregations
Ceiling()
Abs
ACos
ASin
ATan
Cos()
E
Exp
Floor()
LN
Log
LOG2
Pi
Power
Random
Root
Round
Sin
Sqrt
Tan
Trunc
See more
Logic Functions
Contains
EndWith
IF THEN ELSEIF ELSE
IIf
IsChildTagged
IsEntityType
IsNotNull
IsNull
IsParentTagged
IsTagged
StartsWith
See more
Entities Function
EntitiesByHierarchy()
All
BestChild
BestChildren
BestEntity
EntitiesByAlias
EntitiesByCondition()
EntitiesByDelimitedString
EntitiesByParent()
EntitiesByParentTag
EntitiesByTag
EntitiesByType
EntitiesByValue
EntitiesInsidePolygon
EntityFromContext
NameContains
NameEndsWith
NameStartsWith
Siblings
ValueForEntity
See more
Moving Window Functions
MovingAvg
MovingChange
MovingDiff
MovingDiv
MovingMax
MovingMin
MovingOscillationCoefficient
MovingOutlier
MovingSlope
MovingStep
MovingSum
WeightedMovingAvg
See more
Time and Date Functions
StartofTag()
CurrentScopeIncrement()
TagDuration()
StartOfPreviousTag()
EndOfPreviousTag()
EndOfNextTag()
StartOfNextTag()
EndOfTag()
CurrentScope
CurrentStep
Day
DayOfWeek
DayOfYear
DaysInMonth
DateDiff
EndOf()
EndOfFirstTag
EndOfLastTag()
Hour
Millisecond
Minute
Month
Next
Now
Previous()
Second
Shift
StartOf()
StartOfFirstTag
StartOfLastTag
ToDateTime
Today
Year
ToTimeStep()
See more
Statistical Functions
Average
Count
Cumulative
First
HistoryCumulative
Last
Max
Median
Min
Mode
Normalize
Percentile
StDev
Sum
Variance
See more
Economic Functions
IRR()
NPV()
Data Handling
NullDate()
Replace()
FillGaps()
Null()
NullMinus()
NullPlus()
Replace()
Smooth()
ToDouble()
ToInteger()
See more
Additional Functions
IsOpportunity()
TablesIntersection()
TableKey()
How do I use a depth dependent scope?
DepthValue()
DynoCard()
IsChildTagged()
LastValue()
PVTValue()
Rank()
TableValue()
TableValueAggregated()
ValueFromChildren()
ValueFromParent()
WorkspaceDictionary()
WorkspaceEnumeration()
WorkspaceList()
WorkspaceValue()
See more
Directional Functions
CoordinateDegree()
CoordinateUTM()
IsInsidePolygon()
MinDistance()
MinDistanceToPolygon()
ToDepthStep()
See more
Machine Learning Functions
DetectAnomaly()
DetectChangePoint()
DetectSpike()
Predict()
PredictScore()
Forecast()
See more
Voronoi
AggregateVoronoiCell()
VoronoiArea()
VoronoiCellEntitiesCount()
DCA Functions
DCAModelDate()
DCAModelParameter()
DCAModelValue()