Skip Navigation

Analytics Dashboard JSON Developer Guide

`columns` Properties

Use the columns property to add a column to a step query source in Compact form 2.0.

Example: Aggregate measure column defined in Compact form 2.0

1"columns": [
2    {
3        "field": [
4            "sum",
5            "Amount"
6        ]
7    }
8]

Example: Non-aggregate columns defined in Compact form 2.0

1"columns": [
2    {
3        "field": "Customer_Name",
4        "name": "Customer_Name"
5    },
6    {
7        "field": "Product_Name",
8        "name": "Product_Name"
9    },
10    {
11        "field": "Profit",
12        "name": "Profit"
13    }
14]

Example: Formula column defined in Compact form 2.0

1"columns": [
2    {
3        "formula": "A*2",
4        "name": "B"
5    }
6]