Markup
Datagrok Markup is a lightweight scripting language used in both the Flex View and Markup viewer. Using Markup, you can combine text narrative, calculations, and Datagrok UI elements like viewers or widgets within a single view.
Unlike traditional programming languages, Markup is intuitive and does not require extensive coding knowledge.
Expressions
To embed an expression, use: #{expression}
Supported expressions
Description | Expression | Output |
---|---|---|
Any entity | x.196900d0-f9e0-11e7-c473-6fef20f86714."Andrew" | Andrew |
Function | x.MissingValuesImputation | MissingValuesImputation |
Aggregations | t.aggr.sum($AGE) | 267266.00 |
Date | date | 2018-03-07 22:53:01.423700 |
Table name | t.name | demog |
Table tag | t.tags[source.file] | demog.xlsx |
Row count | t.rowCount | 5850 |
Selected rows count | t.selection.trueCount | 55 |
Filtered rows count | t.filter.trueCount | 5850 |
Current filters | t.rows.filters | |
Current row | t.currentRow | 12 |
Current column | t.currentCol | USUBJID |
Current cell | t.currentCell | X0273T21000400001 |
Current row value | t.row[USUBJID] | X0273T21000200001 |
Color | color(AGE) | #e5e5ff |
Formula | formula(${AGE} * 2) | 116 |
Value editor | t.editor[USUBJID] | |
Statistics | t.stats.avg(AGE) | 45.69 |
Chart | chart{"type":"Histogram","look":{"valueColumnName":"AGE"}} |
Any entity
Shows any platform entity.
Format:
x.<id>."<name>"
Function
Shows function.
Format:
x.<name>.<option>
Options:
- run - runs action by click.
- link - renders as a link to function that runs action by click.
Aggregations
Shows aggregated value of defined column.
Format:
t.aggr<aggregation>($<column name>)
Aggregations | Description |
---|---|
count | Number of rows |
#values | Number of not null values |
#unique | Number of unique values |
#nulls | Number of nulls |
min | Minimum |
max | Maximum |
sum | Sum |
med | Median |
avg | Average |
stdev | Standard deviation |
variance | Variance |
skew | Skewness |
kurt | Kurtosis |
q1 | First quartile |
q2 | Second quartile |
q3 | Third quartile |
Date
Shows current date and time.
Format:
date
Table name
Shows table name.
Format:
t.name
Table tag
Shows table tag.
Format:
t.tags[<tag name>]
Row count
Shows number of rows.
Format:
t.rowCount
Selected rows count
Shows number of selected rows.
Format:
t.selection.trueCount
Filtered rows count
Shows number of filtered rows.
Format:
t.filter.trueCount
Current filters
Shows list of selected filters.
Format:
t.rows.filters
Current row
Shows current row index.
Format:
t.currentRow
Current column
Shows current column index.
Format:
t.currentCol
Current cell
Shows current cell value.
Format:
t.currentCell
Current row value
Shows current row value in selected column.
Format:
t.row[<column name>]
Color
Shows column's color in HEX format (32 bits).
Format:
color(<column name>)
Formula
Shows result of defined formula, see formulas format there.
Format:
formula(<formula>)
Value editor
Shows text input of specified column in selected row.
Format:
t.editor[<column name>]
Statistics
Shows aggregated value of defined column.
Format:
t.stats.<statistics>(<column name>)
Statistics | Description |
---|---|
count | Number of rows |
#values | Number of not null values |
#unique | Number of unique values |
#nulls | Number of nulls |
min | Minimum |
max | Maximum |
sum | Sum |
med | Median |
avg | Average |
stdev | Standard deviation |
variance | Variance |
skew | Skewness |
kurt | Kurtosis |
q1 | First quartile |
q2 | Second quartile |
q3 | Third quartile |
Chart
Chart markup allows to embed any of Viewers into page.
Format:
chart{"type":"<chart type>","look":{<chart parameters>}}
Chart types:
- Scatter plot
- Line chart
- Bar chart
- Density plot
- Tree map
- Matrix plot
- Histogram
- Filters
- 3D scatter plot
- Grid
- Column viewer
- Calendar
- Trellis plot
- Box plot
- Pie chart
- Heat map
- PC Plot
- Statistics
- Correlation plot
- Map
- Form designer
- Web viewer
- Markup Viewer
- Word cloud
- Network diagram
- Protein viewer
- Globe
- Card
- Viewer host
- R Viewer
See also: