Ask Search:
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 PomponioNicole Pomponio 
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 Pomponio
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
Chrystele BenjaminChrystele Benjamin 
Hello,

I took a recorded course on dataflows and the instructor would zoom in or out seemlessly to show the whole dataflow or just a portion of it.

Anyone knows what the keyboard shortcut is to do that?
Best Answer chosen by Chrystele Benjamin
Amnon KruviAmnon Kruvi
CTRL +
CTRL -
And as a bonus: CTRL <Mouse Scrollwheel>
Thomas IvyThomas Ivy 
Hi I have Datasets and a Dashboard build in my Sandbox in the My Private App. How do I move them to another App, then push that App to production?
Best Answer chosen by Ed (salesforce.com) 
Amnon KruviAmnon Kruvi
If you open the dataset, there is a little edit icon next to the name of the app it's in (My Private App). Click that, and you are able to move it elsewhere:
User-added image
alex birgeralex birger 
Hi All,

I have a question on multiselection of values. In a dashboard, is there a way in a particular chart(bar chart of accounts and revenue as a measure for example) to select multiple bars(accounts) so that other related charts are filtered based on multiple accounts rather than one.
 
Best Answer chosen by alex birger
Akshay AhujaAkshay Ahuja
Hello Alex,

You can choose Selection Type = Multiple Selection in Step properties of bar chart. See below:

User-added image

Also, make sure broadcast selection as facets is checked. This would filter related charts based on selected values.

Hope this helps.

Best Regards,
Akshay