function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jacqueline PassehlJacqueline Passehl 

Selection Binding Across Multiple Datasets in Einstein Analytics with Lists

So I have two graph widgets, coming from two different datasets and then I have one list widget that works for toggling only one of them. I'm trying to get the list to be able toggle both of these graphs instead of only one.

What I've done:

  • Both  graph widgets are "Grouped By" the same value, and the list widget's field value has this value as well. (Which is "Account Name" in this case)-> This is what I did in order to get the first bar graph widget connected to the list.
  • Added the second dataset to the "datasets" array in the list widget as follows : 
    "List_Widget_1": {
                "datasets": [
                    {
                        //Dataset for first bar graph widget
                        "id": "0Fb1I000000fzv4SAA",
                        "label": "DTC Opportunity",
                        "name": "DTC_Opportunity_SAMPLE",
                        "url": "/services/data/v40.0/wave/datasets/0Fb1I000000fzv4SAA"
                    },
                    {
                        //Dataset for second bar graph widget
                        "id": "0Fb1I000000TR9bSAG",
                        "label": "Opportunities",
                        "name": "opportunities",
                        "url": "/services/data/v40.0/wave/datasets/0Fb1I000000TR9bSAG"
                    }
                ]
  • Added a filter inside the second bar graph's code as follows; ("Account_Name" is what the first graph has in its "groups" array also in the list's "groups" array)
"filters": [
                        "Account.Name",
                        "{{column(List_Widget_1.selection,[\"Account_Name\"]).asObject()}}"
                    ]

Note: I understand the comment syntax in this code is incorrect, I just put it this point for question clarification purposes.​

I was following along with this video, so I thought everything I've done here should work; however the second widget fails to display anything and it says the following when I click "more details":

This widget can't be displayed because of a problem with the underlying step
​Use any of these supported operators: Equals,Does Not Equal, and Contains.


Anyone run into a problem like this before and have any insight? I can post the whole json code for the dashboard as well if needed.

Lawrence Peter 15Lawrence Peter 15
Please could you post the Json code
 
Mahesh_GollaMahesh_Golla
The Filter should be kept in one more array, like an object. 

Please find the correct JSON below.

"filters": [
                [
                ​​​​"Account.Name", "{{column(List_Widget_1.selection,[\"Account_Name\"]).asObject()}}" 
                ]
            ]

Hope this helps!
 
Mahesh_GollaMahesh_Golla
The Filter should be kept in one more array, like an object. 

Please find the correct JSON below. 
{
    "measures": [
        [
            "count",
            "*"
        ]
    ],
    "groups": [
        "fcstrevlight__Account__c.OwnerId.Name"
    ],
    "filters": [
        [
            "fcstrevlight__Account__c.OwnerId.Name",
            "{{cell(UserData.result, 0, \"Name\").asObject()}}"
        ]
    ]
}

Hope this helps!