Answers - Salesforce Trailblazer Community
Ask Search:
Ole MinksOle Minks 
Hello together,

I have strange behavior. For the folowing Trail (https://trailhead.salesforce.com/content/learn/projects/quick-start-einstein-analytics; Step 3) i should try out the conversational query function. Its no problem to ask the qeustion and select the option afterwards "clip to dashboard". But then i cant find it under my dataset as a query so i could drag it into my dashboard. Do i miss something or do i look at the wrong place? 

User-added image

User-added image

User-added image

Thank you in advance
Ole
 
Best Answer chosen by Ole Minks
Andrew GordineerAndrew Gordineer
Had the same issue. Here is my workaround: 
1. Click the '+' symbol next to "DTC Opportunities"
User-added image
2. Type the query from Trailhead into the box labeled "What do you want to see..."
User-added image
3. Click "Done"
User-added image
4. Drag the newly created "Opportunity_Name_1" query onto the table widget. 
User-added image
5. Verify Step on Trailhead. 
Tom JansenTom Jansen 
Hello all,

I know this is kind of a copy question, but I already found the cookbook to set up the Einstein Bot to fetch Knowledge Articles.

The problem that I'm having is that my bot seems to have no rights for knowledgearticleversion. 

I see the following error in the bot logs: "An Apex error occurred: System.QueryException: sObject type 'knowledgearticleversion' is not supported. "

Because when I execute the code in anonymous, it works just fine.

Has someone else stumbled upon this problem and found a solution for this?
Best Answer chosen by Tom Jansen
Tom JansenTom Jansen
I found the answer myself, way easier than I thought.

You just have to give the rights in the permission set for bots.
Read and View All rights for the Knowledge Object.
Sam LairdSam Laird 
I've followed the instructions here https://help.salesforce.com/articleView?id=pardot_b2bma_assign_permissions.htm&type=5 but, I'm trying to give the connector the permission, I get this error:  The user license doesn't allow the permission: Use Analytics
Best Answer chosen by Sam Laird
Kevin DickeyKevin Dickey
Hi Sam,
I was having a lot of issues as well. It seems the information I was sent had wrong information. Here is the correct information I just got from support that worked:

For your convenience, I've listed out the specific steps that are needed, but please let me know if I can elaborate:

** Enable Replication in Salesforce:

- In Salesforce, click Setup.
- Enter "Analytics" in the Quick Find box on the left side, then select Settings.
- Select Enable Replication, and then click Save.

** Enable Campaign Influence in your org:

- In Salesforce, go to Setup.
- In the Quick Find search bar, search for “Campaign Influence Settings”
- If you do not Campaign Influence already enabled, click Enable. Save.

** Assign the "Analytics Embedded App" Permission Set license to all Salesforce users who need access to B2B Marketing Analytics.

- In the Setup menu, click Manage Users | Users.
- Click the name of a user you want to have access to B2B Marketing Analytics.
- Position the cursor over Permission Set License Assignments and click Edit Assignments.
- Select the "Analytics Embedded App" permission set license and click Save.

** In Salesforce, assign your Pardot connector user (username:) the Manage Einstein Analytics permission set.

- From Setup, enter Users in the Quick Find box, then select Users.
- Select your connector user with username 
- In the Permission Set Assignments related list, click Edit Assignments.
- To assign a permission set, select it under Available Permission Sets and click Add. Save.

** In Salesforce, create a new custom permission set: "Use Analytics"

- Setup > search for Permission Sets.
- Follow the remaining steps in each article below:
https://help.salesforce.com/articleView?id=pardot_b2bma_assign_user.htm&type=5

** Assign any Salesforce users who should have access to B2B Marketing Analytics the "Use Analytics" permission set you just created.

- From Setup, enter Users in the Quick Find box, then select Users.
- Select your user.
- In the Permission Set Assignments related list, click Edit Assignments.
- To assign a permission set, select it under Available Permission Sets and click Add. Save.

Please let me know once these steps have been taken, and I can double-check that the setup is completed. Thank you!
Connor SmallConnor Small 
I am trying to add text labels to a dashboard and I cannot find the text widget? is this only available inside the analytics studio.
Best Answer chosen by Connor Small
Rachel FrazerRachel Frazer
As far as I can tell, you can only add text at the component level using the Dashboards tab. You can add a Title, Subtitle and Footer to an individual component.
Add Component Popup
michele tancorramichele tancorra 
Hi all,
I have a dashboard that is based on a dataset (A).
I want to change dataset A with dataset B (this datasaet have the same fields but different values).
Is possible to change dataset without change the entire dashboard? (es. modifing the JSON of the dashboard)

tks
Best Answer chosen by michele tancorra
Akshay AhujaAkshay Ahuja
Hello Michele,

Yes. You can change the dataset reference in the dashboard JSON. Here are the steps:

1. Open the new dataset as a lens. Press Ctrl + E on Windows (or Cmd + E on Mac). This will open the JSON code for that lens. Go to the bottom and copy the dataset definition. Looks something like this:

User-added image

2. Go to the dashboard and open it in JSON mode (Press Ctrl + E on Windows or Cmd + E on Mac). Go to the bottom section and replace the dataset definition. Basically remove definition for dataset A and add daatset definition for B.

3. Search for the reference of dataset A in all the steps. You can do a Ctrl + F and serach for dataset A. Replace each one of them with Dataset B. If it a step in compact form, then the dataset definition will be in above form (as shown in screenshot). If the step is is in SAQL form, then you just have to replace the name of the dataset in the load statement.

4. Click Done. If done correctly, the dashboard would reference the new dataset.

Before doing this, make sure that all the field names in both datasets are same.

Hope this helps. Thank you.

Best Regards,
Akshay
Michael BergerMichael Berger 
I am trying to do my first dashboard in Einstein Analytics using the campaign object.  When I have done classic reports and dashboards it's very easy to filter on the Campaign record type which is essential for the dashboards I am building.  When I created the dataflow into Analytics there was no option in the Field Selector to choose Campaign Record Type. The only thing I had available was the record type ID which is the long hexadecimal field and not helpful.  Any thoughts on how to overcome this?
Best Answer chosen by Jayson (salesforce.com) 
Federico GriggioFederico Griggio

An augment transformation should do. 
You load the record type object and link it via the record type id

https://help.salesforce.com/articleView?id=bi_integrate_augment_transformation.htm&type=5

Sridhar VynojuSridhar Vynoju 
"filters": [ [ "OneDate", "{{row(OneDate_1.selection, [0], [\"min\", \"max\"]).asDateRange(\"date('OneDate_Year', 'OneDate_Month', 'OneDate_Day')\")}}", "><" ] ]
 
{
    "label": "test2",
    "mobileDisabled": false,
    "state": {
        "steps": {
            "OneDate_1": {
                "type": "aggregateflex",
                "datasets": [
                    {
                        "name": "OneMeasureCaseData",
                        "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw6hSAA",
                        "id": "0Fb1P000000bw6hSAA"
                    }
                ],
                "query": {
                    "groups": [
                        "OneDate"
                    ],
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ]
                },
                "broadcastFacet": true,
                "receiveFacet": true,
                "isGlobal": false,
                "useGlobal": true,
                "selectMode": "single",
                "visualizationParameters": {
                    "options": {}
                }
            },
            "OneDate_Year_1": {
                "type": "aggregateflex",
                "query": {
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ],
                    "groups": [
                        "OneDate_Year"
                    ],
                    "filters": [
                        [
                            "OneDate",
                            "{{row(OneDate_1.selection, [0], [\"min\", \"max\"]).asDateRange(\"date('OneDate_Year', 'OneDate_Month', 'OneDate_Day')\")}}",
                            "><"
                        ]
                    ]
                },
                "visualizationParameters": {
                    "options": {},
                    "type": "chart",
                    "parameters": {
                        "visualizationType": "hbar",
                        "autoFitMode": "keepLabels",
                        "theme": "wave",
                        "title": {
                            "label": "",
                            "fontSize": 14,
                            "subtitleLabel": "",
                            "subtitleFontSize": 11,
                            "align": "center"
                        },
                        "showValues": true,
                        "axisMode": "multi",
                        "binValues": false,
                        "bins": {
                            "breakpoints": {
                                "low": 0,
                                "high": 100
                            },
                            "bands": {
                                "low": {
                                    "label": "",
                                    "color": "#B22222"
                                },
                                "medium": {
                                    "label": "",
                                    "color": "#ffa500"
                                },
                                "high": {
                                    "label": "",
                                    "color": "#008000"
                                }
                            }
                        },
                        "dimensionAxis": {
                            "showAxis": true,
                            "showTitle": true,
                            "title": "",
                            "customSize": "auto",
                            "icons": {
                                "useIcons": false,
                                "iconProps": {
                                    "column": "",
                                    "fit": "cover",
                                    "type": "round"
                                }
                            }
                        },
                        "measureAxis1": {
                            "sqrtScale": false,
                            "showAxis": true,
                            "customDomain": {
                                "showDomain": false
                            },
                            "showTitle": true,
                            "title": ""
                        },
                        "measureAxis2": {
                            "sqrtScale": false,
                            "showAxis": true,
                            "customDomain": {
                                "showDomain": false
                            },
                            "showTitle": true,
                            "title": ""
                        },
                        "legend": {
                            "show": true,
                            "showHeader": true,
                            "inside": false,
                            "descOrder": false,
                            "position": "right-top",
                            "customSize": "auto"
                        },
                        "tooltip": {
                            "customizeTooltip": false,
                            "showDimensions": true,
                            "dimensions": "",
                            "showMeasures": true,
                            "measures": "",
                            "showPercentage": true,
                            "showNullValues": true,
                            "showBinLabel": true
                        },
                        "trellis": {
                            "enable": false,
                            "showGridLines": true,
                            "flipLabels": false,
                            "type": "x",
                            "chartsPerLine": 4,
                            "size": [
                                100,
                                100
                            ]
                        },
                        "applyConditionalFormatting": true,
                        "showActionMenu": true,
                        "columnMap": {
                            "trellis": [],
                            "plots": [
                                "count"
                            ],
                            "dimensionAxis": [
                                "OneDate_Year"
                            ]
                        }
                    }
                },
                "datasets": [
                    {
                        "id": "0Fb1P000000bw79SAA",
                        "name": "OneMeasureClosedCaseData",
                        "label": "OneMeasureClosedCaseData",
                        "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw79SAA"
                    }
                ],
                "useGlobal": true,
                "isGlobal": false,
                "broadcastFacet": true,
                "receiveFacet": true,
                "selectMode": "single"
            }
        },
        "widgets": {
            "dateselector_1": {
                "type": "dateselector",
                "parameters": {
                    "defaultFiscalMode": false,
                    "calendarTypeSwitchingAllowed": true,
                    "absoluteModeEnabled": true,
                    "relativeModeEnabled": true,
                    "presetsEnabled": true,
                    "title": "OneDate",
                    "instant": false,
                    "showActionMenu": true,
                    "displayMode": "filter",
                    "filterStyle": {
                        "titleColor": "#54698D",
                        "valueColor": "#16325C"
                    },
                    "step": "OneDate_1"
                }
            },
            "chart_1": {
                "type": "chart",
                "parameters": {
                    "visualizationType": "hbar",
                    "autoFitMode": "keepLabels",
                    "theme": "wave",
                    "title": {
                        "label": "",
                        "fontSize": 14,
                        "subtitleLabel": "",
                        "subtitleFontSize": 11,
                        "align": "center"
                    },
                    "showValues": true,
                    "axisMode": "multi",
                    "binValues": false,
                    "bins": {
                        "breakpoints": {
                            "low": 0,
                            "high": 100
                        },
                        "bands": {
                            "low": {
                                "label": "",
                                "color": "#B22222"
                            },
                            "medium": {
                                "label": "",
                                "color": "#ffa500"
                            },
                            "high": {
                                "label": "",
                                "color": "#008000"
                            }
                        }
                    },
                    "dimensionAxis": {
                        "showAxis": true,
                        "showTitle": true,
                        "title": "",
                        "customSize": "auto",
                        "icons": {
                            "useIcons": false,
                            "iconProps": {
                                "column": "",
                                "fit": "cover",
                                "type": "round"
                            }
                        }
                    },
                    "measureAxis1": {
                        "sqrtScale": false,
                        "showAxis": true,
                        "customDomain": {
                            "showDomain": false
                        },
                        "showTitle": true,
                        "title": ""
                    },
                    "measureAxis2": {
                        "sqrtScale": false,
                        "showAxis": true,
                        "customDomain": {
                            "showDomain": false
                        },
                        "showTitle": true,
                        "title": ""
                    },
                    "legend": {
                        "show": true,
                        "showHeader": true,
                        "inside": false,
                        "descOrder": false,
                        "position": "right-top",
                        "customSize": "auto"
                    },
                    "tooltip": {
                        "customizeTooltip": false,
                        "showDimensions": true,
                        "dimensions": "",
                        "showMeasures": true,
                        "measures": "",
                        "showPercentage": true,
                        "showNullValues": true,
                        "showBinLabel": true
                    },
                    "trellis": {
                        "enable": false,
                        "showGridLines": true,
                        "flipLabels": false,
                        "type": "x",
                        "chartsPerLine": 4,
                        "size": [
                            100,
                            100
                        ]
                    },
                    "applyConditionalFormatting": true,
                    "showActionMenu": true,
                    "columnMap": {
                        "trellis": [],
                        "plots": [
                            "count"
                        ],
                        "dimensionAxis": [
                            "OneDate_Year"
                        ]
                    },
                    "step": "OneDate_Year_1"
                }
            }
        },
        "filters": [],
        "gridLayouts": [
            {
                "name": "Default",
                "numColumns": 12,
                "rowHeight": "normal",
                "version": 1,
                "pages": [
                    {
                        "label": "Untitled",
                        "name": "ec349400-d7b5-45cf-bb26-d777f45295c4",
                        "widgets": [
                            {
                                "row": 0,
                                "column": 0,
                                "rowspan": 1,
                                "colspan": 3,
                                "name": "dateselector_1",
                                "widgetStyle": {
                                    "backgroundColor": "#FFFFFF",
                                    "borderEdges": [
                                        "all"
                                    ],
                                    "borderColor": "#E6ECF2",
                                    "borderWidth": 1,
                                    "borderRadius": 4
                                }
                            },
                            {
                                "row": 1,
                                "column": 0,
                                "rowspan": 5,
                                "colspan": 7,
                                "name": "chart_1",
                                "widgetStyle": {}
                            }
                        ],
                        "navigationHidden": false
                    }
                ],
                "selectors": [],
                "style": {
                    "backgroundColor": "#F2F6FA",
                    "gutterColor": "#C5D3E0",
                    "cellSpacingX": 8,
                    "cellSpacingY": 8,
                    "fit": "original",
                    "alignmentX": "left",
                    "alignmentY": "top"
                }
            }
        ],
        "dataSourceLinks": [],
        "widgetStyle": {
            "backgroundColor": "#FFFFFF",
            "borderEdges": [],
            "borderColor": "#E6ECF2",
            "borderWidth": 1,
            "borderRadius": 0
        }
    },
    "datasets": [
        {
            "name": "OneMeasureClosedCaseData",
            "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw79SAA",
            "id": "0Fb1P000000bw79SAA"
        },
        {
            "name": "OneMeasureCaseData",
            "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw6hSAA",
            "id": "0Fb1P000000bw6hSAA"
        }
    ]
}

 
Best Answer chosen by Sridhar Vynoju
Akshay AhujaAkshay Ahuja
Hello Sridhar,

Can you try the following syntax for the Date filter:
"filters": 
[
    [ "OneDate", 
      "{{row(OneDate_1.selection, [], [\"min\",\"max\"]).asObject()}}", 
      ">=<=" 
    ]
]

Best Regards,
Akshay
Best Answer chosen by Rakhi Shrivastava
shahul mtshahul mt
Hey Rakhi,

Take the dataflow of that dataset ,edit it .Click the sfdcdigest node of the opportunity object where the object is extracted and in the  field option you can add more fields.after adding it click the  save button .When saving it a pop up menu will appear wether to proppgate or not.Choose the option to propogate .After that update the dataflow and run it.

if its find helpful mark this as best.else reply 
 
Aydin Can PolatkanAydin Can Polatkan 
Currently I can sort bar segments of a stacked column chart in asc/desc order or keep it unsorted. However I would like to sort them in a custom fashion like in the image. How to do it with custom SAQL or XMD?

Reorder Bar Segments
Best Answer chosen by Aydin Can Polatkan
Aydin Can PolatkanAydin Can Polatkan
Dear Akshay, thanks for your efforts and your answer.

Indeed I used a similar approach using the SAQL mode. However I also wanted to get rid of the numbers in the legend. Therefore I edited the XMD .json file as well.

Here is my complete answer to the question. (http://www.aydincanpolatkan.com/blog/2527)
Nicole CarielloNicole Cariello 
I am building out our Einstein Bot in Partial and I cannot save Intents. Has anyone else had this issue? I can click to Edit and then type in the intent but on save nothing is saved
Best Answer chosen by Nicole Cariello
Stephanie MurrayStephanie Murray
Sooooooo, feeling really dumb but I was clicking Save after entering in a customer input. I needed to hit ENTER after every input in order to get a list below. Posting in case this is root of anyone else's problem and they had a long week as well?

User-added image