columns Properties

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

Aggregate measure column defined in Compact form 2.0

"columns": [
    {
        "field": [
            "sum",
            "Amount"
        ]
    }
]

Non-aggregate columns defined in Compact form 2.0

"columns": [
    {
        "field": "Customer_Name",
        "name": "Customer_Name"
    },
    {
        "field": "Product_Name",
        "name": "Product_Name"
    },
    {
        "field": "Profit",
        "name": "Profit"
    }
]

Formula column defined in Compact form 2.0

"columns": [
    {
        "formula": "A*2",
        "name": "B"
    }
]