I have defined a toggle control for user to select whether the table should be pivoted or not.  Here is the code of my static (Toggle) object:

"static_1": {
                "broadcastFacet": true,
                "columns": {},
                "label": "Display Mode",
                "selectMode": "singlerequired",
                "type": "staticflex",
                "values": [
                    {
                        "Display": "Pivoted",
                        "value": true,
                        "value2": false
                    },
                    {
                        "Display": "Non-Pivoted",
                        "value": false,
                        "value2": true
                    }
                ],
                "numbers": [],
                "strings": [],
                "groups": []
            },

Ignore the value2 for now.  I plan to use them for other stuff.
 
Then, in my table properties, I have defined this static control as the "pivoted" value:

...
        "minColumnWidth": 40,
        "mode": "variable",
        "numberOfLines": 1,
        "pivoted": "{{cell(static_1.selection,0,\"value\").asObject()}}",
        "showActionMenu": true,
        "showRowIndexColumn": false,
        "verticalPadding": 8,
...

Once I have made this change, the dashoard correctly allows me to toggle the pivoted view.  But when I try to "save" the dashboard, I receive the following error:
 
  Value does not match expected type at [line:1, column:1529]

I even tried using SAQL to ensure I'm selecting a BOOLEAN value:

q = foreach q generate 'ROLL_IND' as 'ROLL_IND', (case when 'ROLL_IND' == \"C\" then true else false end) as 'booleanField';

and then using this booleanfield value in the property:

...
        "minColumnWidth": 40,
        "mode": "variable",
        "numberOfLines": 1,
        "pivoted": "{{cell(lens_2.result, 0, \"booleanField\").asObject()}}",
        "showActionMenu": true,
        "showRowIndexColumn": false,
        "verticalPadding": 8,
...

But all in vain.  I still receive the same error:
  Value does not match expected type at [line:1, column:1529]


Has anyone else come across such requirement and  have got it to work successfully?

Any help / hints would be appreciated.

Regards,
Raviraj Khare 
 

Hi Everyone,

I made new dashboards in the Default Sales App. How do I make a particular dashboard default while running the app. 

Thanks,
Anuj

HI Every one,

 

    I created few dashboards for my salesforce application. I want to make one of these dashboards as default. When user clicks on 'Dashboards' tab, default dashboards should open.

 

 

Can any one please help me, in configuring this requirement.

 

Thanks,

Naresh