Skip to main content
For my query this works fine in a stacked column chart,

 

"groups": 

 

[

 

    ["MyDate__c_Year","MyDate__c_Month"],

 

       "MyCategory__c"                    

 

]

 

But when I add a static step with the below value it won't let me use it in the groups of the other query,

 

"Date_1": {                

 

    "type": "staticflex",

 

    "values": [{                       

 

        "display": "MyDate",                        

 

        "value": ["MyDate__c_Year","MyDate__c_Month"]                   

 

    }],

 

This doesn't work,

 

"groups": 

 

[

 

    "{{column(Date_1.selection, [\"value\"]).asObject()}}",

 

        "MyCategory__c"                    

 

]

 

We have multiple date fields and I want to be able to swap which one is being used, but I can't quite get the syntax right.
4 respuestas
  1. 1 jun 2017, 19:47
    James,

     

    Change to use a cell binding rather than column, as you don't want an array in your groups node.

     

    "groups": 

     

    [

     

        "{{cell(Date_1.selection, 0, \"value\").asObject()}}",

     

            "MyCategory__c"                    

     

    ]

     

     
0/9000